At minimum, a Vantage table must have a table name, table type, and one column defined. If you need to undo a table definition at any time, click Reset to delete your entries and begin again.
- In the Navigator, double-click Databases.
-
In the Object List Viewer:
- Locate the database and schema where you want to create a table.
-
Click
to show tables, then click again to add a table.
-
In the General tab:
- Type a Name for the new table.
- Complete the other optional fields.
-
In the Columns tab, click Add. For each column you add to the table:
- Type the Name of the new column.
- Select the Data Type.
- In Length, type the maximum data length allowed for column data if appropriate for the selected type.
-
Type the maximum Precision allowed for numeric column data.
The precision of a numeric is the total count of digits in the whole number (both sides of a decimal). For example, the number 3068.443 has a precision of 7. The precision must be a positive number.
-
Type the maximum Scale allowed for numeric column data.
The scale of a numeric is the count of decimal digits in the fractional part of the number to the right of the decimal point. For example, the number 3068.443 has a scale of 3. The scale of an integer is considered zero, therefore, scale can be zero or a positive number.
- Select Null if data values in this column can be null.
- Select Unique if data values in this column must be unique.
- [Optional] Add a Comment if appropriate.
- [Optional] Click Column Grouping and add any grouping information.
- [Optional] Click Indexes and add indexes for this table.
- [Optional] Click Constraints and add constraint information.
- [Optional] Click Miscellaneous and complete any information.
-
Click SQL to review the SQL DDL.
To modify the CREATE TABLE statement, return to previous steps to change your selections. You can also copy and paste the text into an SQL Editor to make edits.
- Click Commit.