Editing a table

To edit a table, open the “Table” management form by double clicking on it. In this interface, the table can be renamed and comments can be added. You can also specify the schema associated with this table:

edit table window

 

1.                        You can further add/edit the description of the table by clicking on the “Description” tab:

description table

 

2.                        Furthermore, you can also view the DDL script for the current table by clicking on the “Script” tab:

script table

Note that Columns, Indexes, Constraints, Keys and Triggers can be edited in this form. Editing the aforementioned properties is further discussed in the upcoming sections.

 

Available in: Free, Starter, Professional and Enterprise Editions