如何用sql语句获得此数据库下的所有表？

[chendd2001]

如何用sql语句获得此数据库下的所有表？

[saucer]

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'

[mjhnet]

select name from sysobjects where type='U'

就是会多一个dtproperties表

最好

select name from sysobjects where type='U' and name<>='dtproperties'

[CrazyFor]

exec sp_tables

[joygxd]

select name from sysobjects where xtype='u' and status>0

[ldcr520]

select name from sysobjects where type='U'
sp_tables

[erigido]

exec sp_tables

[mjhnet]

exec sp_tables

还会返回系统表