The Table Metadata virtual table (ID 2000000136) contains data about the tables in database. The following table describes the fields in the Table Metadata virtual table.
| Field | Description |
|---|---|
TableNo | The ID for the table object. |
Table Name | Specifies the name of the table object. |
Caption | Specifies the caption of the table in the language that has been selected. |
DataPerCompany | Sets whether the table data applies to only the current company (No) or all companies (Yes) in the database. |
LookupPageID | Specifies the ID of the page that is used for lookup. |
DrilldownPageID | Specifies the ID of the page that is used for drill down. |
DataCaption Fields | Specifies one or more fields that will be used as captions when a record from this table is displayed in a page. |
PasteIsValid | Specifies whether inserting records into this table using the paste command is enabled. |
LinkedObject | Specifies whether to link to SQL Server objects. |
DataIsExternal | Specifies whether the data is from an external table which means that the data is not managed by Microsoft Dynamics NAV. DataIsExternal is set if the LinkedObject Property is set to Yes or the TableType Property is set to CRM or ExternalSQL . |
TableType | Specifies whether the table type is Normal, CRM, or ExternalSQL. |
Except for the DataIsExternal field, the fields in the virtual table correspond directly to C/AL properties on the table objects. For more information, see Table Properties.
To access and view the Table Metadata virtual table, you must create a tabular-type page. For more information, see How to: Create a Page to View a Virtual Table