Hi,I've created a view using the following T-SQL:SELECT dbo.Product.Name, dbo.Product.ShortDescription, dbo.Product.FullDescription, dbo.ProductOption.Name AS ProductOption, dbo.ProductOptionValue.Name AS OptionValue, dbo.SkuVsProductOptionValue.ID AS UniqueKey, dbo.Sku.SkuCode, dbo.Product.IdFROM dbo.Product WITH (nolock) INNER JOIN dbo.Sku WITH (nolock) ON dbo.Product.Id = dbo.Sku.Product_id INNER JOIN dbo.SkuVsProductOptionValue WITH (nolock) ON dbo.Sku.Id = dbo.SkuVsProductOptionValue.Sku_id INNER JOIN dbo.ProductOptionValue WITH (nolock) ON dbo.ProductOptionValue.Id = dbo.SkuVsProductOptionValue.ProductOptionValue_id INNER JOIN dbo.ProductOption WITH (nolock) ON dbo.ProductOption.Id = dbo.ProductOptionValue.ProductOption_id
As you might imagine the column "UniqueKey" is unique and non-null. But when I try to define a full text index using the wizard, I get told that "A unique column must be defined on this table/view". Do I need to do something in order to indicate that UniqueKey is indeed Unique, or am I missing something else?Cheers,Matt
Define unique column on view
Posted - 2010-02-17 : 06:03:43
