Question: How can I find and report on SQL Server tables with LOB columns but where the table has no PRIMARY KEY? I’m classing an LOB column as ‘TEXT’, ‘NTEXT’,’IMAGE’ ,’XML’, ‘VARBINARY’,’NVARCHAR(MAX)’ & ‘VARCHAR(MAX)’.
Read on for the answer.
A Fine Slice Of SQL Server
Question: How can I find and report on SQL Server tables with LOB columns but where the table has no PRIMARY KEY? I’m classing an LOB column as ‘TEXT’, ‘NTEXT’,’IMAGE’ ,’XML’, ‘VARBINARY’,’NVARCHAR(MAX)’ & ‘VARCHAR(MAX)’.
Read on for the answer.