Hi everybody,
Do you know why this query
select tc1.PK_Field, col.Table_Name, col.Column_Name, col.Data_Type, col.Character_Maximum_Length from INFORMATION_SCHEMA.COLUMNS col INNER JOIN INFORMATION_SCHEMA.TABLES tab on col.Table_Name = tab.Table_Name
LEFT JOIN (SELECT ccu.Column_Name as PK_Field, tc.Table_Name from INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc
INNER JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE ccu
ON tc.CONSTRAINT_name = ccu.CONSTRAINT_name
WHERE CONSTRAINT_type = 'PRIMARY KEY') tc1 ON col.Table_Name = tc1.Table_Name
WHERE tab.Table_Type = 'BASE TABLE' AND col.Character_Maximum_Length >=50 order by 2,3
misses lots of fields in some table?
If it's not broken, fix it until it is.
My Blog 
