SELECT * FROM sys.tables AS tbl INNER JOIN sys.extended_properties AS p ON p.major_id=tbl.object_id AND p.minor_id=0 AND p.class=1
Aug 5, 2008
How to select the table have extended property
Subscribe to:
Post Comments (Atom)
Tips about BI,DWH and so on..
SELECT * FROM sys.tables AS tbl INNER JOIN sys.extended_properties AS p ON p.major_id=tbl.object_id AND p.minor_id=0 AND p.class=1
No comments:
Post a Comment