Table Metadata Virtual Table

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
ID The ID for the table object.
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.
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 Dynamics NAV.

DataIsExternal is set if the LinkedObject Property is set to Yes or the TableType Property is set to 365 for Sales or ExternalSQL .
TableType Specifies whether the table type is Normal, 365 for Sales, or ExternalSQL.
ExternalName Specifies the name of the original table in the external database.
ObsoleteState Marks whether the table is or will become obsolete (deprecated).
ObsoleteReason Specifies why a table has been marked as Pending or Obsolete in the ObsoleteState property.
DataClassification Specifies the classification of data in the table.

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

See Also

Virtual Tables