3.3w+
社区成员
...全文
当前发帖距今超过3年，不再开放新的回复
发表回复
mjhnet 2003-05-08
exec sp_tables
还会返回系统表
还会返回系统表
erigido 2003-05-07
exec sp_tables
ldcr520 2003-05-07
select name from sysobjects where type='U'
sp_tables
sp_tables
joygxd 2003-05-07
select name from sysobjects where xtype='u' and status>0
CrazyFor 2003-05-07
exec sp_tables
mjhnet 2003-05-07
select name from sysobjects where type='U'
就是会多一个dtproperties表
最好
select name from sysobjects where type='U' and name<>='dtproperties'
就是会多一个dtproperties表
最好
select name from sysobjects where type='U' and name<>='dtproperties'
saucer 2003-05-07
select name from sysobjects where type='U'
in 2000, you could also do
select table_name from INFORMATION_SCHEMA.TABLES where table_type = 'BASE TABLE'
in 2000, you could also do
select table_name from INFORMATION_SCHEMA.TABLES where table_type = 'BASE TABLE'
