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)

 
 

DBLX SQL Guide