(1)先学习这个
SELECT name, id, xtype, uid, info, status, base_schema_ver, replinfo, parent_obj, crdate,
ftcatid, schema_ver, stats_schema_ver, type, userstat, sysstat, indexdel, refdate,
version, deltrig, instrig, updtrig, seltrig, category, cache
FROM sys.sysobjects
(2)根据上面的查询结果分析,只要写
SELECT name FROM sysobjects where xtype='U'
转载于:https://www.cnblogs.com/miclu/archive/2007/10/10/919479.html