加上排序,可能就跟企业管理器显示的一样了
select A.name AS 名称,B.name 所有者,
CASE A.xtype WHEN 'U' THEN '用户' WHEN 'S' THEN '系统' END AS 类型,
crdate AS 创建日期 from dbo.sysobjects A INNER JOIN dbo.sysusers B
ON A.uid=B.uid
WHERE A.xtype='U' OR A.xtype='S'
ORDER BY A.name
select A.name AS 名称,B.name 所有者,
CASE A.xtype WHEN 'U' THEN '用户' WHEN 'S' THEN '系统' END AS 类型,
crdate AS 创建日期 from dbo.sysobjects A INNER JOIN dbo.sysusers B
ON A.uid=B.uid
WHERE A.xtype='U' OR A.xtype='S'