Hi,
How to find full text index is exist in the table or not
like that how to find normal index is exist in the table or not
Thanks in adv.
---> Murali <----
full text index is exist or not
Hot Topic
- searching xml column
- Weekly Sales Join
- Multi-valued Parameter
- Management Studio Express CTP update now available
- Unable to access Report Manager
- cannot install samples
- SSIS - Handling different types of record in same flat file source
- function to display the numbers 1-12 in detail of table
- June CTP - How to inspect for Empty String
- Problem making backup of an SQL Server database
SQL Server
- Why is the DisableEventHandlers property not accessible for eventhandler containers
- Full Text Search component problem
- Help in Understing Logic for Generating Row Numbers?
- Profiling SSIS Package
- Date field cannot be null!
- I hate this
- Poor performance import text file
- Security consideration for Pull Subscription
- ADOMD.NET 8.0 dependencies for connecting to both AS 2000 and AS 2005
- cube processing error - perhaps someone can explain
full text index is exist or not
JED03110
Please refer to Books Online "Obtaining Full-Text Property Values using Transact-SQL Functions" http://msdn2.microsoft.com/ms142579.aspx
In your case you should use OBJECTPROPERTY function and TableHasActiveFulltextIndex property. OBJECTPROPERTY(table_id, 'TableHasActiveFulltextIndex') will return a value of 1 when at least one column of a table is added for indexing.
Your code will look like:
SELECT OBJECTPROPERTY(OBJECT_ID('MySchema.MyTable'), 'TableHasActiveFulltextIndex');
GO
parth1729
Hi,
thaks Lefter, I found small solution to find index is exist or not using
sp_helpindex 'tablename'
and
fulltext index is exist or not in the table using
sp_help_fulltext_tables @table_name='tablename'
bye
--> Murali <--