The Tables schema returns information about TABLE objects by accessing the Advanced SQL Engine Data Dictionary views. It will access DBC.TABLES[V] or DBC.TABLES[V]X Data Dictionary view based on UseXViews Connection setting.
Column Name | Data Type | Description |
---|---|---|
Id | String | Returns a unique Id for the TABLE. |
CatalogName | String | This field is always set to NULL. |
SchemaName | String | Returns the name of the DATABASE in which TABLE object resides. |
Name | String | Returns the name of the TABLE object. |