Table "Table Metadata"
Virtual table that provides metadata information about all tables in the system. This table enables introspection of table properties, settings, and characteristics for development and administration purposes.
Remarks
The Table Metadata table is a fundamental metadata source that provides detailed information about table definitions, properties, and configuration settings. It includes information about table types, data classification, permissions, and various table attributes. This table is essential for development tools, metadata analyzers, and administrative utilities that need to understand table structures and properties. The information covers both base application tables and those added by extensions, providing a complete view of the data model.
Properties
| Name | Value |
|---|---|
| DataPerCompany | False |
| Scope | Cloud |
| InherentPermissions | rX |
Fields
| Name | Type | Description |
|---|---|---|
| ID | Integer | The unique identifier number of the table. |
| Name | Text[30] | The name of the table as defined in the AL source code. |
| Caption | Text[80] | The caption text displayed for this table in the user interface. |
| DataPerCompany | Boolean | Indicates whether the table stores data separately for each company or globally. |
| LookupPageID | Integer | The page ID used for lookup operations on this table. |
| DrillDownPageId | Integer | The page ID used for drill-down operations on this table. |
| DataCaptionFields | Text[80] | The fields used to generate captions for records in this table. |
| PasteIsValid | Boolean | Indicates whether paste operations are valid for this table. |
| LinkedObject | Boolean | Indicates whether this table is linked to an external object or system. |
| DataIsExternal | Boolean | Indicates whether the table data is stored externally rather than in the main database. |
| TableType | Option | The type of table indicating its purpose and storage characteristics. |
| ExternalName | Text[248] | The external name used when the table is accessed from external systems. |
| ObsoleteState | Option | The obsolete state indicating whether the table is obsolete, pending removal, or removed. |
| ObsoleteReason | Text[248] | The reason provided when the table was marked as obsolete. |
| DataClassification | Option | The data classification category for privacy and compliance purposes. |
| ReplicateData | Boolean | Indicates whether data in this table should be replicated to other environments. |
| CompressionType | Option | The compression type applied to the table for storage optimization. |
| "App ID" | Guid | The application identifier that contains this table. |
| InherentPermissions | Text[5] | The inherent permissions defined for this table (Read, Insert, Modify, Delete). |
| InherentEntitlements | Text[5] | The inherent entitlements required to access this table. |
| Scope | Option | The deployment scope where this table is available (Cloud or OnPrem). |
| Access | Option | The access level of the table (Public or Internal). |
| "AL Namespace" | Text[500] | The AL namespace of the object. |
| SystemId | Guid | |
| SystemCreatedAt | DateTime | |
| SystemCreatedBy | Guid | |
| SystemModifiedAt | DateTime | |
| SystemModifiedBy | Guid | |
| SystemRowVersion | BigInteger |