dtproperties


Description

Database properties - System table that stores metadata and properties about database objects, used for database management and version control.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int identity 4 null

Data field - id information for dtproperties business operations

objectid int 4 null

Object ID - Reference to the database object

property varchar 64 null

Data field - property information for dtproperties business operations

value varchar 255 null

Property value - Value of the database property

uvalue nvarchar 510 null

Unicode value - Unicode representation of the property value

lvalue image 2147483647 null

Large value - Large text or binary property value

version int 4 (0)

Version - Version number of the property

Indexes

Constraint Name Type Sort Column(s)
pk_dtproperties Primary key Asc/Asc id + property

Relationships