This topic has not yet been rated - Rate this topic

FullTextTableReference Class

SQL Server 2012

Represents the FREETEXTTABLE and CONTAINSTABLE table references.

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

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

Syntax

C++

JScript

[SerializableAttribute]
public class FullTextTableReference : TableReferenceWithAlias

The FullTextTableReference type exposes the following members.

Constructors

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

Top

Properties

	Name	Description
	Alias	Gets or sets the alias of the reference. (Inherited from TableReferenceWithAlias.)
	Columns	Gets the list of columns to search.
	FirstTokenIndex	Gets or sets the first token index. (Inherited from TSqlFragment.)
	FragmentLength	Gets the fragment length. (Inherited from TSqlFragment.)
	FullTextFunctionType	Gets or sets the full text function type.
	Language	Gets or sets an optional language whose resources will be used for wordbreaking, stemming, and thesaurus and noise-word removal.
	LastTokenIndex	Gets or sets the last token index. (Inherited from TSqlFragment.)
	PropertyName	Gets or sets an optional property specification value.
	ScriptTokenStream	Gets or sets a list of token streams. (Inherited from TSqlFragment.)
	SearchCondition	Gets or sets the search condition/text to search.
	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.)
	TableName	Gets or sets the table name.
	TopN	Gets or sets the optional number of top-ranked results to return.

Top

Methods

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

Reference

Microsoft.SqlServer.TransactSql.ScriptDom Namespace

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD