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?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
Here's how it works:
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top