Create or Edit Tables

Use the table designer to create tables or change their structure while reviewing the generated SQL before it runs.

Create a Table

1. In Connections, expand the connection, database, and schema where you want to create the table.

2. Right-click Tables and select Create.

   

3. Enter a Table Name, then select + to add each column.

   Configure the name and data type for each column. Depending on the data type, you can also set its length or scale. Use Nullable, Identity, and Default to define the column’s behavior.

   Changes Preview updates as you edit the table.

   

4. To define a primary key, open the Primary Key tab, select +, and choose the key column. Add more rows for a composite key.

   

5. Review Changes Preview, then select Apply and Close. Select Yes in the confirmation dialog to run the SQL.

Edit a Table

1. In Connections, right-click the table and select Alter.

2. Edit existing columns or select + to add a column. You can change the data type, length, scale, nullable status, identity behavior, or default value.

   The example below adds a non-null created_at column with a CURRENT_TIMESTAMP default. Changes Preview shows the generated ALTER TABLE statement.

   

3. Review the SQL, select Apply and Close, then select Yes to apply the changes.