获得数据库里所有表的名称
(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'
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'