GetExtraTableInfo
Returns additional information about the listed tables beyond what may be obtained using the standard methods.
Result Set Columns
Name | Type | Description |
CatalogName | String | The database containing the table. |
SchemaName | String | The schema containing the table. |
TableName | String | The name of the table. |
TableType | String | The table type. |
Description | String | A description of the table. |
IsHidden | Boolean | If the table is hidden or not. |
InternalId | String | The internalid of the table if this is a custom table. |
ScriptId | String | The scriptid of the table if this is a custom table. |
IsCustomTable | Boolean | A boolean indicating if this is a custom table. |
SchemaFile | String | The xsd schema file the entity for the table is defined under. |
NamespaceURI | String | The namespace for the table used when constructing SOAP messages. |
SearchType | String | The search type used for the table used during SELECT statements. |
SearchName | String | The name of the search used for the table during SELECT statements. |
ListName | String | The name of the list this table represents. Only given a value if this table is a child table. |
SubType | String | The subtype of object, used when describing item types. |
CostingMethod | String | The costing method(s) avaialble. Used when describing a type of item type. |
JoinColumnNames | String | Available columns that may be joined on. |
JoinColumnTypes | String | Available types that may be joined on (correlated with the JoinColumnNames). |
JoinCriteriaNames | String | Available criteria names that may be joined on. |
JoinCriteriaTypes | String | Avaialble criteria types that may be joined on (correlated with the JoinCriteriaNames). |
SupportsGetDeleted | Boolean | A boolean indicating if this table supports GetDeleted. |