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.