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)]
public bool RowGuidCol { get; set; }

Property Value

Type: System.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.

Return to top
Show: