Viewing table names and definitions

SQL Guide : Using SQL for database administration : Managing tables : Viewing table names and definitions

To view the table names and definitions in your database, use the LIST and DESCRIBE statements.

Procedure

▪To list all user-created tables, issue the following command:

LIST TABLES

▪To list all system and user-created tables, issue the following command:

SELECT * FROM TABLES

TABLES is a system view that contains all the tables. In the output, the table names can be found in the column TABLE_NAME.

▪To view the basic table information, issue the following command:

DESCRIBE TABLE <table_name> NICE

DESCRIBE TABLE table_name with the keyword NICE prints the table name, the storage type used, list of parent and child tables, columns, column types, column precisions, column nullability, whether column is primary key and whether column is sec key. In RAW format, the create statement is printed along with create statements of associated indexes and constraints.

▪To view the table definition, issue the following command:

DESCRIBE TABLE <table_name> RAW

DESCRIBE TABLE table_name with the keyword RAW prints the CREATE TABLE create statement for the table, including the CREATE statements of associated indexes and constraints.