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)
No comments:
Post a Comment