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)
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)
posted on 2006-10-26 17:24 Clark Chan 阅读(608) 评论(0) 编辑 收藏 举报