Select Add Column option in the Table or Column context menu in the Database Object View to launch the Add Column dialog box, in which you can add a new column to the selected table or to generate a query to add a column to the selected table.

The Add Column dialog box contains the following options:

• Table Name —Displays the name of the table in which to add the new column.
• Column Name —Enter the name of the column to add.
• Data Type —Select the data type of the column to add.
• Size —Select the size of the column to be added. This control is enabled only if the data type you select supports variable-sized data.
• Precision —Select the precision of the column to add. This control is enabled only if the data type you select supports precision.
• Scale —Select the scale of the column to add. This control is enabled only if the data type you select supports scale.
• Is Nullable —Specifies a nullable column. This control is enabled only if the data type you select allows nullable columns.
• Create Column —Creates a new column in the database table and adds that new column to the Tree View under the selected table.
• Generate Query —Generates a query to add a new column to the database table and launches a new Execute SQL tab that contains the query content.