Full-Text indexes in SSMS 2008 R2

full-text-searchssms

I created a new database, a few tables, and full-text index & catalog using SQL Server Management Studio without any problem. I wanted to copy the T-SQL creation scripts for each of those to include them in my documentation. I can get the creation scripts for the database, tables, foreign keys, and the catalog but I can't seem to find the full-text index. I've checked the related table's Script Table As->CREATE To and it's not there, nor is it with the Catalog. Any ideas? Is it because I'm only running SQL Server Standard edition?

Best Answer

In SSMS

  • Tools
  • Options
  • "SQL Server Object Explorer"
  • "Script full text catalogs"

Default is "false"...