SQL Server 2000 元数据应用（一）：获得数据库的用户表

SQL Server 2000 元数据应用（一）：获得数据库的用户表

SELECT   OBJECT_NAME (so.id)  AS   OBJECT_NAME ,  USER_NAME (so.uid)  AS   USER_NAME , 
      so.type  AS  TYPE, so.crdate  AS  DATE_CREATED, 
      fg.FILE_GROUP  AS  FILE_GROUP
FROM  sysobjects so  LEFT   OUTER   JOIN
          ( SELECT  s.groupname  AS  FILE_GROUP, i.id  AS  id
          FROM  sysfilegroups s  INNER   JOIN
               sysindexes i  ON  i.groupid  =  s.groupid
          WHERE  (i.indid  <   2 )) fg  ON  so.id  =  fg.id
WHERE  (so.type  =  N ' U ' )  AND  ( permissions (so.id)  &   4096   <>   0 )  AND  ( ObjectProperty (so.id, 
      N ' IsMSShipped ' )  =   0 )
ORDER   BY   USER_NAME (so.uid),  OBJECT_NAME (so.id)

转载于:https://www.cnblogs.com/ClarkChan/archive/2006/10/26/540933.html