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. |
ViewDefinition | String | The SQL command that is used to create the view. |
IsUpdatable | Boolean | If the ViewDefinition conains the clause WITH CHECK OPTION the view is considered updatable. This column is set to true if this clause exists, otherwise it is false. |