SoftadminDatabaseMetaData.DatabaseColumn

View exposing Database Designer meta data regarding database columns.

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.columns together with column_id.
column_id int Yes No No column_id used to make joins to sys.columns together with object_id.
FriendlyName nvarchar(300) Yes No No Friendly name of the column.
IsPotentiallyIdentifyingPersonalData bit Yes No No Indicates whether the column is marked as potentially containing personal data. NULL means not set.
ColumnOrdinal bigint Yes No No Column ordinal of the column in Database Designer (not necessarily the same as the database table).