Dela via


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
Public Property RowGuidCol As Boolean
public bool RowGuidCol { get; set; }
public:
property bool RowGuidCol {
    bool get ();
    void set (bool value);
}
/** @property */
public boolean get_RowGuidCol ()

/** @property */
public void set_RowGuidCol (boolean value)
public function get RowGuidCol () : boolean

public function set RowGuidCol (value : boolean)

Property Value

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. If False, the column is not automatically updated with a unique GUID value.

Remarks

Updated text:

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.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Example

How to: Create, Alter, and Remove a Table in Visual Basic .NET

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

Column Class
Column Members
Microsoft.SqlServer.Management.Smo Namespace

Other Resources

ALTER TABLE (Transact-SQL)
Working with Database Objects

Change History

Release

History

New content:
  • Modified the description for the RowGuidCol property.