|
What are the rules to use the ROWGUIDCOL property to define a globally unique identifier column?A table can have only one ROWGUIDCOL column
A ROWGUIDCOL column must be defined by using the uniqueidentifier data type.
To insert a globally unique value, we need to apply DEFAULT definition on the column that uses the NEWID function to generate a globally unique value.
To enforce uniqueness in ROWGUIDCOL column, the UNIQUE constraint should be used.What are the rules to use the ROWGUIDCOL property to define a globally unique identifier column?Only one column can exist per table that is attached with ROWGUIDCOL property. One can then use $ROWGUID instead of column name in select list.
|
