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)

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Design)> _
Public Property RowGuidCol As Boolean 
    Get 
    Set
'Usage
Dim instance As Column 
Dim value As Boolean 

value = instance.RowGuidCol

instance.RowGuidCol = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)]
public bool RowGuidCol { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase|SfcPropertyFlags::Design)]
public:
property bool RowGuidCol {
    bool get ();
    void set (bool value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase|SfcPropertyFlags.Design)>]
member RowGuidCol : bool with get, set
function get RowGuidCol () : boolean 
function set RowGuidCol (value : boolean)

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).

Remarks

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.

Examples

Working with Database Objects

See Also

Reference

Column Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

ALTER TABLE (Transact-SQL)