Can anybody tell me from which system tables / catalog views can I get the
Full Text Image Type for a Column in SQL 2005 (Yukon).
TIA
Pra

SELECT *
FROM INFORMATION_sCHEMA.COLUMNS
WHERE CHARACTER_OCTET_LENGTH > 8000 OR
CHARACTER_OCTET_LENGTH = -1
you will get all image, varbinary(max), text, varchar(max), ntext,
nvarchar(max) and xml data type columns.
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"Pra

news:O3EPbsw$FHA.4012@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Can anybody tell me from which system tables / catalog views can I get the
> Full Text Image Type for a Column in SQL 2005 (Yukon).
>
> TIA
> Pra

>
>
没有评论:
发表评论