FullTextCatalog Members
The FullTextCatalog object represents a MicrosoftSearch full-text catalog.
The following tables list the members exposed by the FullTextCatalog type.
Public Constructors
Nome | Description | |
---|---|---|
FullTextCatalog | Overloaded. Initializes a new instance of the FullTextCatalog class. |
Torna all'inizio
Protected Fields
Nome | Description | |
---|---|---|
m_ExtendedProperties | (inherited from SqlSmoObject ) |
Torna all'inizio
Public Properties
(see also Protected Properties )
Nome | Description | |
---|---|---|
ErrorLogSize | Gets the size of the error log. | |
FileGroup | Gets or sets the file group on which this catalog resides. | |
FullTextIndexSize | Gets the size of the full-text index. | |
HasFullTextIndexedTables | Gets a Boolean property value that specifies whether the full-text catalog is used by at least one table for index data storage. | |
ID | Gets the ID value that uniquely identifies the MicrosoftSearch full-text catalog. | |
IsAccentSensitive | Gets or sets the Boolean property value that specifies whether the referenced full-text catalog is accent sensitive. | |
IsDefault | Gets or sets the Boolean property value that specifies whether the referenced full-text catalog is the default catalog for full-text index creation. | |
ItemCount | Gets the total number of full-text indexed rows in the catalog. | |
Name | Gets or sets the name of the object. (inherited from NamedSmoObject) | |
Owner | Gets or sets the owner of the full-text catalog. | |
Parent | Gets or sets the Database object that is the parent of the FullTextCatalog object. | |
PopulationCompletionAge | Gets the time since the last successful full-text catalog population. | |
PopulationCompletionDate | Gets the date and time of the last successful full-text catalog population. | |
PopulationStatus | Gets the population status of the referenced full-text catalog. | |
Properties | Gets a collection of Property objects that represent the object properties. (inherited from SqlSmoObject) | |
RootPath | Gets or sets the path to the operating system directory that is used as the primary path for MicrosoftSearch full-text catalog storage. | |
State | Gets the state of the referenced object. (inherited from SmoObjectBase) | |
UniqueKeyCount | Gets the approximate number of words uniquely addressable in the referenced full-text catalog. | |
Urn | Gets the Uniform Resource Name (URN) address value that uniquely identifies the object. (inherited from SqlSmoObject) | |
UserData | Gets or sets user-defined data associated with the referenced object. (inherited from SmoObjectBase) |
Torna all'inizio
Protected Properties
Nome | Description | |
---|---|---|
ExecuteForScalar | Gets or sets the Boolean property value that specifies whether the object is set to the execute for scalar option. (inherited from SqlSmoObject) | |
ObjectInSpace | Gets the Boolean property value that specifies whether the object exists in isolation or whether it is connected to the instance of Microsoft SQL Server directly or indirectly. (inherited from SqlSmoObject) | |
PresetProperties | Gets or sets the preset properties of the referenced object. (inherited from SqlSmoObject) | |
ScalarResult | Gets the scalar result for the referenced object. (inherited from SqlSmoObject) |
Torna all'inizio
Public Methods
(see also Protected Methods )
Nome | Description | |
---|---|---|
Alter | Updates any FullTextCatalog object property changes on the instance of Microsoft SQL Server. | |
Create | Creates a full-text catalog on the instance of Microsoft SQL Server as defined by the FullTextCatalog object. | |
Deny | Overloaded. Denies the specified set of permissions for the specified grantees on the full text catalog. | |
Drop | Drops the full-text catalog that is represented by the FullTextCatalog object. | |
EnumErrorLogs | Enumerates a list of error logs for the referenced full-text catalog. | |
EnumObjectPermissions | Overloaded. Enumerates a list of permissions for the full-text catalog. | |
Equals | Overloaded. (inherited from Object ) | |
GetHashCode | (inherited from Object ) | |
GetType | (inherited from Object ) | |
Grant | Overloaded. Grants the specified set of permissions to the specified grantees on the full text catalog. | |
Initialize | Overloaded. Initializes the object and forces the properties be loaded. (inherited from SqlSmoObject) | |
ReadErrorLog | Overloaded. Returns the information in the error log. | |
Rebuild | Overloaded. Rebuilds the entire full-text catalog. | |
ReferenceEquals | (inherited from Object ) | |
Refresh | Refreshes the script name. (inherited from ScriptNameObjectBase) | |
Reorganize | Forces a master merge of the referenced full-text catalog. | |
Revoke | Overloaded. Revokes a previously granted set of permissions from a grantee or grantees on the full text catalog. | |
Script | Overloaded. Generates a Transact-SQL script that can be used to re-create the full-text catalog. | |
StartPopulation | Starts the population of the full-text catalog. | |
StopPopulation | Stops the population of the full-text catalog. | |
ToString | Returns a String that represents the referenced object. (inherited from SqlSmoObject) |
Torna all'inizio
Protected Methods
Nome | Description | |
---|---|---|
AlterImpl | (inherited from SqlSmoObject ) | |
AlterImplFinish | (inherited from SqlSmoObject ) | |
AlterImplInit | (inherited from SqlSmoObject ) | |
AlterImplWorker | (inherited from SqlSmoObject ) | |
AppendCommaText | (inherited from ScriptNameObjectBase ) | |
AppendWithCommaText | (inherited from ScriptNameObjectBase ) | |
AppendWithOption | (inherited from ScriptNameObjectBase ) | |
BindDefaultImpl | (inherited from SqlSmoObject ) | |
BindRuleImpl | (inherited from SqlSmoObject ) | |
CheckCollation | (inherited from SqlSmoObject ) | |
CheckObjectState | Overloaded. Validates the state of the referenced object. (inherited from SqlSmoObject) | |
CheckObjectStateImpl | (inherited from SqlSmoObject ) | |
CheckTextCorectness | (inherited from ScriptNameObjectBase ) | |
CheckTextModeSupport | (inherited from ScriptNameObjectBase ) | |
CheckVersion80 | Checks the validity of the object on Microsoft SQL Server 2000. (inherited from SqlSmoObject) | |
CheckVersion80SP3 | Checks the validity of the object on Microsoft SQL Server 2000 SP3. (inherited from SqlSmoObject) | |
CheckVersion90 | Check the validity of the object on Microsoft SQL Server 2005. (inherited from SqlSmoObject) | |
CheckVersionBelow90 | (inherited from SqlSmoObject ) | |
CleanObject | Cleans the referenced object. (inherited from ScriptNameObjectBase) | |
CreateImpl | (inherited from SqlSmoObject ) | |
CreateImplFinish | (inherited from SqlSmoObject ) | |
CreateImplInit | (inherited from SqlSmoObject ) | |
DropImpl | (inherited from SqlSmoObject ) | |
DropImplWorker | (inherited from SqlSmoObject ) | |
Finalize | (inherited from Object ) | |
ForceTextModeOnTextBody | Enforces text mode on the text body. (inherited from ScriptNameObjectBase) | |
FormatSqlVariant | (inherited from SqlSmoObject ) | |
GenerateDataSpaceScript | (inherited from SqlSmoObject ) | |
GetBindDefaultScript | (inherited from SqlSmoObject ) | |
GetBindRuleScript | (inherited from SqlSmoObject ) | |
GetBoolParameter | Overloaded. (inherited from SqlSmoObject ) | |
GetBraketNameForText | (inherited from ScriptNameObjectBase ) | |
GetDateTimeParameter | (inherited from SqlSmoObject ) | |
GetDateTimeParameterAsInt | (inherited from SqlSmoObject ) | |
GetDBName | Gets the database name associated with the object. (inherited from SqlSmoObject) | |
GetEnumParameter | (inherited from SqlSmoObject ) | |
GetFragOptionString | (inherited from SqlSmoObject ) | |
GetGuidParameter | (inherited from SqlSmoObject ) | |
GetIsTextDirty | Determines whether the text value is consistent with stored value. (inherited from ScriptNameObjectBase) | |
GetParameter | Overloaded. (inherited from SqlSmoObject ) | |
GetPropValue | (inherited from SqlSmoObject ) | |
GetPropValueOptional | (inherited from SqlSmoObject ) | |
GetPropValueOptionalAllowNull | (inherited from SqlSmoObject ) | |
GetRealValue | (inherited from SqlSmoObject ) | |
GetScriptIncludeExists | (inherited from ScriptNameObjectBase ) | |
GetScriptingOptionsForCreate | (inherited from SqlSmoObject ) | |
GetServerName | Gets the name of the instance of Microsoft SQL Server with which the object is associated. (inherited from SqlSmoObject) | |
GetSqlServerVersionName | Gets the version name of the instance of Microsoft SQL Server with which the object is associated. (inherited from SqlSmoObject) | |
GetStringParameter | Overloaded. (inherited from SqlSmoObject ) | |
GetTextBody | Overloaded. Returns the text body. (inherited from ScriptNameObjectBase) | |
GetTextForScript | (inherited from ScriptNameObjectBase ) | |
GetTextHeader | (inherited from ScriptNameObjectBase ) | |
GetTextMode | Determines whether the script name is using text mode. (inherited from ScriptNameObjectBase) | |
GetTextProperty | (inherited from ScriptNameObjectBase ) | |
GetTimeSpanParameterAsInt | (inherited from SqlSmoObject ) | |
GetUrnRecursive | Overloaded. (inherited from SqlSmoObject ) | |
ImplInitialize | (inherited from SqlSmoObject ) | |
IsCollectionDirty | (inherited from SqlSmoObject ) | |
IsObjectDirty | Determines whether the referenced object is consistent with the stored object. (inherited from ScriptNameObjectBase) | |
IsObjectInitialized | Verifies whether the object has been initialized. (inherited from SqlSmoObject) | |
IsObjectInSpace | Verifies whether the object is isolated or connected to the instance of Microsoft SQL Server. (inherited from SqlSmoObject) | |
IsVersion80SP3 | (inherited from SqlSmoObject ) | |
MarkDropped | (inherited from SqlSmoObject ) | |
MarkForDropImpl | (inherited from SqlSmoObject ) | |
MemberwiseClone | (inherited from Object ) | |
PostAlter | (inherited from SqlSmoObject ) | |
PostCreate | (inherited from SqlSmoObject ) | |
PostDrop | (inherited from SqlSmoObject ) | |
RenameImpl | (inherited from NamedSmoObject ) | |
RenameImplWorker | (inherited from NamedSmoObject ) | |
ScriptAlter | (inherited from SqlSmoObject ) | |
ScriptAnsiQI | (inherited from ScriptNameObjectBase ) | |
ScriptChangeOwner | (inherited from NamedSmoObject ) | |
ScriptCreate | (inherited from SqlSmoObject ) | |
ScriptDdl | (inherited from SqlSmoObject ) | |
ScriptDrop | (inherited from SqlSmoObject ) | |
ScriptImpl | Overloaded. (inherited from SqlSmoObject ) | |
ScriptImplWorker | (inherited from SqlSmoObject ) | |
ScriptInformativeHeaders | (inherited from ScriptNameObjectBase ) | |
ScriptRename | (inherited from NamedSmoObject ) | |
SetCollectionTextMode | (inherited from ScriptNameObjectBase ) | |
SetParentImpl | (inherited from SqlSmoObject ) | |
SetTextBody | (inherited from ScriptNameObjectBase ) | |
SetTextHeader | (inherited from ScriptNameObjectBase ) | |
SetTextMode | (inherited from ScriptNameObjectBase ) | |
SwitchTextMode | (inherited from ScriptNameObjectBase ) | |
ThrowIfTextIsDirtyForAlter | (inherited from ScriptNameObjectBase ) | |
Trace | (inherited from SqlSmoObject ) | |
UnbindDefaultImpl | (inherited from SqlSmoObject ) | |
UnbindRuleImpl | (inherited from SqlSmoObject ) | |
UpdateCollectionState2 | (inherited from SqlSmoObject ) |
Torna all'inizio
Vedere anche
Riferimento
FullTextCatalog Class
Microsoft.SqlServer.Management.Smo Namespace
Altre risorse
Implementing Full-Text Search
Documentazione relativa alla ricerca full-text
CREATE FULLTEXT CATALOG (Transact-SQL)