Logo 
Search:

SQL Server Articles

Submit Article
Home » Articles » SQL Server » Meta Data FunctionsRSS Feeds

FULLTEXTCATALOGPROPERTY Function

Posted By: Sarita Patel     Category: SQL Server     Views: 2457

This article explains about FULLTEXTCATALOGPROPERTY function in sql server with examples.

FULLTEXTCATALOGPROPERTY function returns value of specified property and full-text catalog name.


Syntax of FULLTEXTCATALOGPROPERTY Function :

FULLTEXTCATALOGPROPERTY ( catalog_name , property )

catalog_name is a name of the full-text catalog.

property is a name of full-text catalog property. Below is the table containing properties, return value and description of it. 

Property

Description

PopulateStatus

0 = Idle 
1 = Full population in progress
2 = Paused 
3 = Throttled 
4 = Recovering 
5 = Shutdown 
6 = Incremental population in progress 
7 = Building index 
8 = Disk is full. Paused.
9 = Change tracking

ItemCount

Number of full-text indexed items currently in the full-text catalog.

IndexSize

Size of the full-text index in megabytes.

UniqueKeyCount

Number of unique words (keys) that make up the full-text index in this catalog. This is an approximation of the number of nonnoise words stored in the full-text catalog.

LogSize

Size, in bytes, of the combined set of error logs associated with a Microsoft® Search Service full-text catalog.

PopulateCompletionAge

The difference in seconds between the completion of the last full-text index population and 01/01/1990 00:00:00.


Return type of FULLTEXTCATALOGPROPERTY function is an integer.



Examples of FULLTEXTCATALOGPROPERTY Function :

Example 1 : Use of FULLTEXTCATALOGPROPERTY function in select clause

SELECT FULLTEXTCATALOGPROPERTY('Cat_Desc','ItemCount')

Output
10

Above example returns number of items in the Cat_Desc catalog.
  
Share: 


Didn't find what you were looking for? Find more on FULLTEXTCATALOGPROPERTY Function Or get search suggestion and latest updates.

Sarita Patel
Sarita Patel author of FULLTEXTCATALOGPROPERTY Function is from United States.
 
View All Articles

Related Articles and Code:


 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!