GetExtraTableInfo
Returns comprehensive metadata about specified tables, including additional attributes beyond standard table definitions.
Result Set Columns
| Name | Type | Description |
| CatalogName | String | The name of the database that contains this table. |
| SchemaName | String | The name of the schema where this table is located. |
| TableName | String | The designated name of this table. |
| TableType | String | Specifies the type of table, such as view, base table, or temporary. |
| Description | String | A detailed description providing context for this table's purpose. |
| IsHidden | Boolean | Indicates whether this table is hidden from standard views. |
| InternalId | String | The unique internal ID assigned to this table, used for custom tables. |
| ScriptId | String | The script identifier for this table, relevant for custom tables. |
| IsCustomTable | Boolean | True or false value indicating if this table is a custom table. |
| SchemaFile | String | The XSD schema file that defines this table's entity. |
| NamespaceURI | String | The namespace URI for this table, important for constructing SOAP messages. |
| SearchType | String | Specifies the search type applicable for this table during SELECT operations. |
| SearchName | String | The name of the predefined search associated with this table for SELECT operations. |
| ListName | String | The name of the list represented by this table. Populated only if the table represents a child list. |
| SubType | String | Indicates the subtype of the object, useful for item classifications. |
| CostingMethod | String | Lists the available costing methods, used to describe item types. |
| JoinColumnNames | String | A list of columns available for joins, separated by commas with spaces after each comma. |
| JoinColumnTypes | String | The types corresponding to joinable columns (matches the JoinColumnNames list). |
| JoinCriteriaNames | String | A list of joinable criteria names, separated by commas with spaces after each comma. |
| JoinCriteriaTypes | String | The types corresponding to joinable criteria (matches the JoinCriteriaNames list). |
| SupportsGetDeleted | Boolean | True or false value indicating if this table supports the GetDeleted operation. |