Remove-RowGuidCol

Remove the rowguidcol property from a column in a table.

Syntax

Remove-RowGuidCol [-SchemaName <String>] [-TableName] <String> [-ColumnName] <String> [<CommonParameters>]

Description

The Remove-RowGuidCol operation removes the rowguidcol property from a uniqueidentifier column in a table.

The Remove-RowGuidCol operation was added in Rivet 0.7.

Related Commands

Parameters

Name Type Description Required? Pipeline Input Default Value
SchemaName String

The table's schema. Default is dbo.

false false dbo
TableName String

The table's name.

true false
ColumnName String

The name of the column that should get the rowguidcol property.

true false

EXAMPLE 1

Remove-RowGuidCol -TableName 'MyTable' -ColumnName 'MyUniqueIdentifier'

Demonstrates how to remove the rowguidcol property from a column in a table. In this example, the dbo.MyTable table's MyUniqueIdentifier column will lose the propery.

EXAMPLE 2

Remove-RowGuidCol -SchemaName 'cstm' -TableName 'MyTable' -ColumnName 'MyUniqueIdentifier'

Demonstrates how to remove the rowguidcol property from a column in a table whose schema isn't dbo, in this case the cstm.MyTable table's MyUniqueIdentifier column will lose the property.