Full-Text Search DDL, Functions, Stored Procedures, and Views

• Transact-SQL Data Definition Language (DDL) Statements

• System Predicates and Functions

• System Metadata Functions

• System Stored Procedures

• System Views – Catalog Views

• System Views – Dynamic Management Views

• CREATE FULLTEXT CATALOG (Transact-SQL)

• CREATE FULLTEXT INDEX (Transact-SQL)

• CREATE FULLTEXT STOPLIST (Transact-SQL)

• CREATE SEARCH PROPERTY LIST (Transact-SQL)

• ALTER FULLTEXT CATALOG (Transact-SQL)

• ALTER FULLTEXT INDEX (Transact-SQL)

• ALTER FULLTEXT STOPLIST (Transact-SQL)

• ALTER SEARCH PROPERTY LIST (Transact-SQL)

• DROP FULLTEXT CATALOG (Transact-SQL)

• DROP FULLTEXT INDEX (Transact-SQL)

• DROP FULLTEXT STOPLIST (Transact-SQL)

• DROP SEARCH PROPERTY LIST (Transact-SQL)

[TOP]

• CONTAINS (Transact-SQL)

• CONTAINSTABLE (Transact-SQL)

• FREETEXT (Transact-SQL)

• FREETEXTTABLE (Transact-SQL)

[TOP]

• COLUMNPROPERTY (Transact-SQL)

• FULLTEXTCATALOGPROPERTY (Transact-SQL)

• FULLTEXTSERVICEPROPERTY (Transact-SQL)

• INDEXPROPERTY (Transact-SQL)

• OBJECTPROPERTY (Transact-SQL)

• OBJECTPROPERTYEX (Transact-SQL)

• SERVERPROPERTY (Transact-SQL)

[TOP]

• sp_fulltext_keymappings (Transact-SQL)

• sp_fulltext_load_thesaurus_file (Transact-SQL)

• sp_fulltext_pendingchanges (Transact-SQL)

• sp_fulltext_service (Transact-SQL)

• sp_help_fulltext_system_components (Transact-SQL)

[TOP]

• sys.fulltext_catalogs (Transact-SQL)

• sys.fulltext_document_types (Transact-SQL)

• sys.fulltext_index_catalog_usages (Transact-SQL)

• sys.fulltext_index_columns (Transact-SQL)

• sys.fulltext_index_fragments (Transact-SQL)

• sys.fulltext_indexes (Transact-SQL)

• sys.fulltext_languages (Transact-SQL)

• sys.fulltext_stoplists (Transact-SQL)

• sys.fulltext_stopwords (Transact-SQL)

• sys.fulltext_system_stopwords (Transact-SQL)

• sys.registered_search_properties (Transact-SQL)

• sys.registered_search_property_lists (Transact-SQL)

[TOP]

• sys.dm_fts_active_catalogs (Transact-SQL)

• sys.dm_fts_fdhosts (Transact-SQL)

• sys.dm_fts_index_keywords (Transact-SQL)

• sys.dm_fts_index_keywords_by_document (Transact-SQL)

• sys.dm_fts_index_keywords_by_property (Transact-SQL)

• sys.dm_fts_index_population (Transact-SQL)

• sys.dm_fts_memory_buffers (Transact-SQL)

• sys.dm_fts_memory_pools (Transact-SQL)

• sys.dm_fts_outstanding_batches (Transact-SQL)

• sys.dm_fts_parser (Transact-SQL)

• sys.dm_fts_population_ranges (Transact-SQL)

[TOP]