Describing a Table


To get a description of a table and its metadata, use the following SQL DESCRIBE syntax:

DESCRIBE TABLE myTable


If the table exists, the description will be returned in a format similar to the following:

Table: constraintsSecondary
Primary_P_Id varchar FOREIGN KEY REFERENCES constraintsPrimary.P_Id,
LastName varchar(30),
FirstName varchar(25),
Address varchar(50),
City varchar(20)