SQL Server Performance

Drop and create a table that has full text search turned on

Discussion in 'SQL Server 2008 General DBA Questions' started by WingSzeto, May 27, 2011.

  1. WingSzeto Member

    What would happen to the full text search on a table A when the table A is dropped and recreated? Would the full text search still be available when the table A is recreated and the full text search would automatically rebuilt the full text index?

  2. Jahanzaib Member

    Full Text catalog will be available after drop the table but you have to define again newly create table in the full text Catalog,when you will define the column then column will have an index

Share This Page