Add Table Dialog Box
- Updated2025-07-21
- 2 minute(s) read
Add Table Dialog Box
Select Add Table in the Database, Tables, or Table context menus in the Database Object View to launch the Add Table dialog box, in which you can add a new table to the selected database or generate a query to add a table.
The Add Table dialog box contains the following options:
- Table Name —Enter the name of the table to add.
- 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 add. 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.
-
Primary Key
—Adds the column as a primary key.
Note One of the added columns must be selected as a primary key.
-
Is Nullable
—Specifies a nullable column. This control is enabled only if the data type you select allows nullable columns.
Note If a column is a primary key, you cannot make the column nullable.
- Grid —Displays the list of columns added.
- Add Column —Adds a column to the grid. You can edit the added column in the grid.
- Remove Column —Removes the selected column from the grid.
- Up and Down —Controls the order of columns in the grid.
- Create Table —Creates a new table and adds the table to the Tree View with the specified table name and list of columns.
- Generate Query —Generates a query to create a new table with the specified table name and list of columns and launches a new Execute SQL tab that contains the query content.