Aug 5, 2008

How to select the table have extended property

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: