Object | Tab option | Description |
---|---|---|
Schema |
General | You can edit the name, label, and various other attributes of the object. |
Documentation | You can provide documentation. | |
Annotation | You can add or delete properties and edit their values. | |
Table space | General | You can edit the name, label, and various other attributes of the object. |
Tables | You can specify the tables. | |
Documentation | You can provide documentation. | |
Annotation | You can add or delete properties and edit their values. | |
Table | General | You can edit the name, label, and various other attributes of the object. |
Columns | You can add or delete columns, reorder the columns by using the up and down arrows, rename columns, select the primary key, select the domain, select the data type, edit the length, specify scale, select not null, select generated, and specify default value/generate expression. | |
Partition Key | You can specify how the key is to be maintained and edit the columns for the key, including the order of the columns. | |
Table spaces | You can select the table space to which the table belongs. | |
Documentation | You can provide documentation. | |
Annotation | You can add or delete properties and edit their values. | |
Columns (in a table) | General | You can edit the name and label. |
Type | You can select the data type and properties of the column (primary key, null or not, and identity). | |
Documentation | You can provide documentation. | |
Annotation | You can add or delete properties and edit their values. | |
Index | General | You can edit the name, label, and schema. |
Details | You can specify whether the index is unique or clustered, add or delete key or include columns, and change the order of the index columns. | |
Documentation | You can provide documentation. | |
Annotation | You can add or delete properties and edit their values. | |
Primary key | General | You can edit the name, label, and various other attributes of the object. |
Columns | You can add or delete columns in the key and reorder the columns by using the up and down arrows. | |
Documentation | You can provide documentation. | |
Annotation | You can add or delete properties and edit their values. | |
Foreign key | General | You can edit the name, label, and various other attributes of the object. |
Details | You can add, delete, or reorder columns in the foreign key. | |
Referential integrity | You can change update and delete preferences. | |
Documentation | You can provide documentation. | |
Annotation | You can add or delete properties and edit their values. | |
Materialized query table | General | You can edit the name, label, and the attributes for how the table is to be refreshed and maintained. |
Columns | You can view the columns and their data types. | |
SQL | You can edit, and validate the SQL expression that is used to define the materialized query table. | |
Documentation | You can provide documentation. | |
Annotation | You can add or delete properties and edit their values. | |
View | General | You can edit the name, label, and various other attributes of the object. |
Columns | You can view the columns and their data types. | |
SQL | You can edit and validate the SQL expression that is used to define the view. | |
Documentation | You can provide documentation. | |
Annotation | You can add or delete properties and edit their values. | |
Sequence | General | You can edit the name, label, and data type. |
Type | You can specify the start, increment, minimum and maximum values of the sequence, and whether the sequence is to cycle. | |
Documentation | You can provide documentation. | |
Annotation | You can add or delete properties and edit their values. | |
Stored Procedure | General | You can edit the name, label, result set, language, parameter style, and external name. |
Parameters | You can change the parameters for the stored procedure. | |
Source | For an SQL procedure, you can change the procedure on which the stored procedure is sourced. | |
Documentation | You can provide documentation. | |
Annotation | You can add or delete properties and edit their values. | |
User-defined function | General | You can edit the name, label, language, parameter style, and external name. |
Return Type | You can edit the data type of the returned value. | |
Parameters | You can change the parameters for the function | |
Source | For an SQL procedure, you can change the procedure on which the stored procedure is sourced. | |
Documentation | You can provide documentation. | |
Annotation | You can add or delete properties and edit their values. | |
User-defined type | General | You can edit the name and label. For user-defined data types, you can also specify the data type, including precision and scale where applicable. |
Custom data types | You can add, delete, and order custom data types. The tab is not applicable for user-defined data types. | |
Documentation | You can provide documentation. | |
Annotation | You can add or delete properties and edit their values. |