UniqueConstraintDefinition Class

Represents the unique or primary key constraint. This class translates 80 syntax into 90 syntax, this should be reflected in the AST, if a differentiator is to be written.

Inheritance Hierarchy

System.Object
  Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragment
    Microsoft.SqlServer.TransactSql.ScriptDom.ConstraintDefinition
      Microsoft.SqlServer.TransactSql.ScriptDom.UniqueConstraintDefinition

Namespace:  Microsoft.SqlServer.TransactSql.ScriptDom
Assembly:  Microsoft.SqlServer.TransactSql.ScriptDom (in Microsoft.SqlServer.TransactSql.ScriptDom.dll)

Syntax

'Declaration
<SerializableAttribute> _
Public Class UniqueConstraintDefinition _
    Inherits ConstraintDefinition
'Usage
Dim instance As UniqueConstraintDefinition
[SerializableAttribute]
public class UniqueConstraintDefinition : ConstraintDefinition
[SerializableAttribute]
public ref class UniqueConstraintDefinition : public ConstraintDefinition
[<SerializableAttribute>]
type UniqueConstraintDefinition =  
    class 
        inherit ConstraintDefinition 
    end
public class UniqueConstraintDefinition extends ConstraintDefinition

The UniqueConstraintDefinition type exposes the following members.

Constructors

  Name Description
Public method UniqueConstraintDefinition Initializes a new instance of the UniqueConstraintDefinition class.

Top

Properties

  Name Description
Public property Clustered Gets or sets a value that indicates whether the constraint is clustered.
Public property Columns Gets a list of constraint columns.
Public property ConstraintIdentifier Gets the name of the constraint. (Inherited from ConstraintDefinition.)
Public property FileStreamOn Gets or sets an optional specification of the file stream. It can be either Identifier or String literal.
Public property FirstTokenIndex Gets or sets the first token index. (Inherited from TSqlFragment.)
Public property FragmentLength Gets the fragment length. (Inherited from TSqlFragment.)
Public property IndexOptions Gets a list of index options.
Public property IsPrimaryKey Gets or sets whether the constraint is both unique and a primary key.
Public property LastTokenIndex Gets or sets the last token index. (Inherited from TSqlFragment.)
Public property OnFileGroupOrPartitionScheme Gets or sets the file group or partition scheme. It might be nulla null reference (Nothing in Visual Basic).
Public property ScriptTokenStream Gets or sets a list of token streams. (Inherited from TSqlFragment.)
Public property StartColumn Gets the starting column. (Inherited from TSqlFragment.)
Public property StartLine Gets the starting line. (Inherited from TSqlFragment.)
Public property StartOffset Gets the fragment start offset value. (Inherited from TSqlFragment.)

Top

Methods

  Name Description
Public method Accept Indicates the entry point for a given visitor. (Overrides TSqlFragment.Accept(TSqlFragmentVisitor).)
Public method AcceptChildren Calls Accept on the children with the given visitor. (Overrides ConstraintDefinition.AcceptChildren(TSqlFragmentVisitor).)
Public method Equals (Inherited from Object.)
Protected method Finalize (Inherited from Object.)
Public method GetHashCode (Inherited from Object.)
Public method GetType (Inherited from Object.)
Protected method MemberwiseClone (Inherited from Object.)
Public method ToString (Inherited from Object.)

Top

Thread Safety

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

See Also

Reference

Microsoft.SqlServer.TransactSql.ScriptDom Namespace