16.00 - Adding a Teradata Table - Teradata Studio

Teradata Studio User Guide

Teradata Studio
March 2017
User Guide
At minimum, a Teradata 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.
  1. In the Administration perspective, click a Teradata connection.
  2. In the Navigator, double-click on the Databases category. The database list opens in the Object List Viewer.
  3. Locate the database and schema where you want to create a table.
  4. In the Object List Viewer, click to show tables, then click it again to add a table. The Create Table form displays.
  5. In the General tab, type a Name for the new table.
  6. Complete the other optional fields on the General tab.
  7. Click Columns and for each column you add to the table, complete the following information:
    1. Type the name of the new column in Name.
    2. Select the Data Type.
    3. In Length, type the maximum data length allowed for column data if appropriate for the selected type.
    4. 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.
    5. 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.
    6. Select Null if data values in this column can be null.
    7. Select Unique if data values in this column must be unique.
    8. [Optional] Add a Comment if appropriate.
  8. [Optional] Click Column Grouping and add any grouping information.
  9. [Optional] Click Indexes and add indexes for this table.
  10. [Optional] Click Constraints and add constraint information.
  11. [Optional] Click Miscellaneous and complete any information.
  12. Click SQL and review the generated statement. 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.
  13. Click Commit to execute the statement and update the table definition on the Database server.