Functionality:
List the general field, fields’ dimensions and field data types in a table.
Syntax:
|
list field,dim,type of T |
// field should be present |
|
dim D |
// List fields having same dimension with D; list all dimension fields when D is absent |
|
depth d |
// Get the depth of the general field |
|
primary key |
// List primary key field(s) |
|
foreign key FK |
// Get foreign key information according to the foreign key name |
Parameter:
|
T |
Table name |
|
D |
Dimension |
|
d |
The depth of a general field; default 1 means excluding the foreign key and default 0 means excluding homo-dimension tables |
|
FK |
Foreign key field; list all composite foreign key in table T and ignore type and dim when FK is absent |
Example:
|
1 |
list field,dim,type of ReturnedPmt primary key |
List information of ReturnedPmt table’s all primary key fields |
|
2 |
list field,dim,type of Orders foreign key fk1 |
List information of Orders table’s foreign key field fk1 |