SQL Server Full-text indexing

CREATE TABLE Document (
ID int NOT NULL,
Name nvarchar (255) is not NULL,
Body nvarchar (max) not NULL);
Go

Create unique index uq_ix_for_document--#这里一定要加一个not The null unique index is used below. Without this, you cannot add a full-text index.
On Document (ID);
Go

Create fulltext Catalog Ftt_clg_for_studio
as default;
Go

Create FULLTEXT Index on Document (Body)
Key index uq_ix_for_document
On Ftt_clg_for_studio;
Go --#可以看出全文索引是没有名字的.

--------------------------------------------------------------------------------------------------------------- ---

SQL Server Full-text indexing