Поделиться через


PivotedTableSource Class

Represents the pivoted table source in a FROM clause.

Inheritance Hierarchy

System.Object
  Microsoft.Data.Schema.ScriptDom.Sql.TSqlFragment
    Microsoft.Data.Schema.ScriptDom.Sql.TableSource
      Microsoft.Data.Schema.ScriptDom.Sql.TableSourceWithAlias
        Microsoft.Data.Schema.ScriptDom.Sql.PivotedTableSource

Namespace:  Microsoft.Data.Schema.ScriptDom.Sql
Assembly:  Microsoft.Data.Schema.ScriptDom.Sql (in Microsoft.Data.Schema.ScriptDom.Sql.dll)

Syntax

'Declaration
<SerializableAttribute> _
Public Class PivotedTableSource _
    Inherits TableSourceWithAlias
[SerializableAttribute]
public class PivotedTableSource : TableSourceWithAlias
[SerializableAttribute]
public ref class PivotedTableSource : public TableSourceWithAlias
[<SerializableAttribute>]
type PivotedTableSource =  
    class
        inherit TableSourceWithAlias
    end
public class PivotedTableSource extends TableSourceWithAlias

The PivotedTableSource type exposes the following members.

Constructors

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

Top

Properties

  Name Description
Public property AggregateFunctionIdentifiers Gets a list of the identifiers that represent the aggregate function.
Public property Alias Gets or sets an optional table alias. (Inherited from TableSourceWithAlias.)
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 InColumns Gets a list of "in columns".
Public property LastTokenIndex Gets or sets the last token index. (Inherited from TSqlFragment.)
Public property PivotColumn Gets or sets the pivot column.
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.)
Public property TableSource Gets or sets the table source.
Public property ValueColumns Gets a list of value columns.

Top

Methods

  Name Description
Public method Accept Entry point for a given visitor. (Overrides TSqlFragment.Accept(TSqlFragmentVisitor).)
Public method AcceptChildren Calls Accept on the children with the given visitor. (Overrides TableSourceWithAlias.AcceptChildren(TSqlFragmentVisitor).)
Public method Equals Determines whether the specified Object is equal to the current Object. (Inherited from Object.)
Protected method Finalize Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.)
Public method GetHashCode Serves as a hash function for a particular type. (Inherited from Object.)
Public method GetType Gets the Type of the current instance. (Inherited from Object.)
Protected method MemberwiseClone Creates a shallow copy of the current Object. (Inherited from Object.)
Public method ToString Returns a string that represents the current object. (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.Data.Schema.ScriptDom.Sql Namespace