Dela via

  • Artikel

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.