SQL Server Management Studio may not include all important parts of your table when you let it write the CREATE TABLE
script. For instance, the full-text index for a table is omitted by default. If you use the full-text search feature, you should make sure that SQL Server Management Studio includes them in the create scripts. You can change the behaviour with these steps:
- Open SQL Server Management Studio
- In the Tools menu click on Options…
- Expand the entry SQL Server Object Explorer and select Scripting
- In the right list locate Script full-text indexes and set it to True
From now on SQL Server Management Studio includes the definition for the full-text indexes in the CREATE TABLE scripts.