PivotedTableReference Class

Represents the pivoted table reference in a FROM clause.

Inheritance Hierarchy

System.Object
  Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragment
    Microsoft.SqlServer.TransactSql.ScriptDom.TableReference
      Microsoft.SqlServer.TransactSql.ScriptDom.TableReferenceWithAlias
        Microsoft.SqlServer.TransactSql.ScriptDom.PivotedTableReference

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

Syntax

'Declaration
<SerializableAttribute> _
Public Class PivotedTableReference _
    Inherits TableReferenceWithAlias
'Usage
Dim instance As PivotedTableReference

[SerializableAttribute]
public class PivotedTableReference : TableReferenceWithAlias

[SerializableAttribute]
public ref class PivotedTableReference : public TableReferenceWithAlias

[<SerializableAttribute>]
type PivotedTableReference =  
    class 
        inherit TableReferenceWithAlias 
    end

public class PivotedTableReference extends TableReferenceWithAlias

The PivotedTableReference type exposes the following members.

Constructors

	Name	Description
	PivotedTableReference	Initializes a new instance of the PivotedTableReference class.

Top

Properties

	Name	Description
	AggregateFunctionIdentifier	Gets the multi-part identifier that represents the aggregate function.
	Alias	Gets or sets the alias of the reference. (Inherited from TableReferenceWithAlias.)
	FirstTokenIndex	Gets or sets the first token index. (Inherited from TSqlFragment.)
	FragmentLength	Gets the fragment length. (Inherited from TSqlFragment.)
	InColumns	Gets a list of the “in columns”.
	LastTokenIndex	Gets or sets the last token index. (Inherited from TSqlFragment.)
	PivotColumn	Gets or sets the pivot column.
	ScriptTokenStream	Gets or sets a list of token streams. (Inherited from TSqlFragment.)
	StartColumn	Gets the starting column. (Inherited from TSqlFragment.)
	StartLine	Gets the starting line. (Inherited from TSqlFragment.)
	StartOffset	Gets the fragment start offset value. (Inherited from TSqlFragment.)
	TableReference	Gets or sets the table reference.
	ValueColumns	Gets a list of the value columns.

Top

Methods

	Name	Description
	Accept	Accepts the visitor. (Overrides TSqlFragment.Accept(TSqlFragmentVisitor).)
	AcceptChildren	Accepts the visitor for Children. (Overrides TableReferenceWithAlias.AcceptChildren(TSqlFragmentVisitor).)
	Equals	(Inherited from Object.)
	Finalize	(Inherited from Object.)
	GetHashCode	(Inherited from Object.)
	GetType	(Inherited from Object.)
	MemberwiseClone	(Inherited from Object.)
	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