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. |