CommonTableExpression Class

Represents the common table expression.

Inheritance Hierarchy

System.Object
  Microsoft.SqlServer.TransactSql.ScriptDom.TSqlFragment
    Microsoft.SqlServer.TransactSql.ScriptDom.CommonTableExpression

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

Syntax

'Declaration
<SerializableAttribute> _
Public Class CommonTableExpression _
    Inherits TSqlFragment
'Usage
Dim instance As CommonTableExpression

[SerializableAttribute]
public class CommonTableExpression : TSqlFragment

[SerializableAttribute]
public ref class CommonTableExpression : public TSqlFragment

[<SerializableAttribute>]
type CommonTableExpression =  
    class 
        inherit TSqlFragment 
    end

public class CommonTableExpression extends TSqlFragment

The CommonTableExpression type exposes the following members.

Constructors

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

Top

Properties

	Name	Description
	Columns	Gets a list of the column names.
	ExpressionName	Gets or sets the expression name.
	FirstTokenIndex	Gets or sets the first token index. (Inherited from TSqlFragment.)
	FragmentLength	Gets the fragment length. (Inherited from TSqlFragment.)
	LastTokenIndex	Gets or sets the last token index. (Inherited from TSqlFragment.)
	QueryExpression	Gets the query definition.
	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.)

Top

Methods

	Name	Description
	Accept	Indicates the entry point for a given visitor. (Overrides TSqlFragment.Accept(TSqlFragmentVisitor).)
	AcceptChildren	Accepts visitor for Children. (Overrides TSqlFragment.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