I am writting a script that automatically recreates database objects that are lost when a sucscription is reinitialized. One of the things that i need to recreate is the full text indexs.
Before i create a new one i want to check and see if one exists and if so drop it (like you do with other objects such as indexes)
I cannot find any examples that would help me do this. The syntaxt that i am trying to create is
If Exists (FullTextIndex_name)