SoftadminDatabaseMetaData.DatabaseTable
View exposing Database Designer meta data regarding database tables.
Add row:
Not allowed
Delete row:
Not allowed
Foreign key:
Not allowed
Columns
| Name | Datatype | Read | Write | Primary key | Description |
|---|---|---|---|---|---|
| object_id | int | Yes | No | No | object_id used to make joins to sys.tables. |
| FriendlyName | nvarchar(300) | Yes | No | No | Table friendly name. |
| TableType | varchar(100) | Yes | No | No |
Table type alias. May be: Fixed Lookup Transaction Directory Lookup Semi transaction Many to many State Derived Precalculated |
| EstimatedMaxRowCount | int | Yes | No | No | The maximum of the estimated row count interval. Always use greater/less than (< >) rather than equals to (=) when comparing to this column as the number may change in future releases. |