Export (0) Print
Expand All

Column.RowGuidCol Property

Gets or sets the Boolean property value that specifies whether the column is automatically updated with a unique GUID value.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design|SfcPropertyFlags.Matrix)]
public bool RowGuidCol { get; set; }

Property Value

Type: Boolean
A Boolean value that specifies whether the column contains an automatically updated unique GUID value.If True, the column is automatically updated with a unique GUID value. Otherwise, False (default).

The RowGuidCol property is equivalent to the ADD or DROP ROWGUIDCOL Transact-SQL statement in the ALTER TABLE statement

When this property is set to True, the column is automatically updated with a unique GUID value. If the data is copied to another table, the GUID value will not be identical to the original column value. There is only one RowGuidCol column allowed per table.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft