Unanswered: Can't create an index on a text field?
Hi: I am very new to MSSQL, using SQL Server 2008 Express and SQL Server Management Studio to configure the tables. The front end is an Access project - but that's not really relevant - I think. Now, I can of course prevent duplication via the user interface, and I plan to do that anyway, but nonetheless, there are certain fields that I would like to create as indexes to prevent duplicates.
I find that the tool will not allow me to do this with a text field. Is this a limitation of SQL, the management console, or am I simply missing it. When I try to setup the index, it shows all of my numeric fields but not my text fields.
ntext, text, and image data types will be removed in a future version of Microsoft SQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead.
yess shammat, it is not easy, clean or straightforward and does not apply to all kinds of data
Full-text indexes can be built on columns that contain formatted binary data, such as Microsoft Word documents, stored in a varbinary(max) or image column. You cannot use the LIKE predicate to query formatted binary data.