Help with table

1. What is help table?
2. What is a table for data?
3. How do you create a table in a database?
4. How do I view a table in Teradata?

What is help table?

The HELP TABLE command creates a list of field names by querying the Teradata Database and deriving the DEFINE list from the table definition.

What is a table for data?

A data table is a document comprising columns, rows and cells that contain specific values. They store information that people can retrieve later and update as needed. The data table title, column headers and row headers can help a user understand the information in the table more clearly.

How do you create a table in a database?

In the Open dialog box, select the database that you want to open, and then click Open. On the Create tab, in the Tables group, click Table. A new table is inserted in the database and the table opens in Datasheet view.

How do I view a table in Teradata?

You can use SHOW TABLE to display the table definition for a PTI table. The output includes the system generated TD_TIMEBUCKET, TD_TIMECODE, and TD_SEQNO columns for PTI Tables. For complete information about SHOW TABLE syntax, see Teradata Vantage™ SQL Data Definition Language Syntax and Examples , B035-1144.