如何获得数据库中的表，要表名（在线）

[super_cha]

用一个sql语句，或者其他方法获得一个库中的所有表名，怎么做？？

[happydreamer]

sp_tables


select name from sysobjects where xtype='U'

[happydreamer]

sp_tables


select name from sysobjects where xtype='U'

[wgy2008]

select name
from sysobjects
where xtype = 'u'

[CrazyFor]

select Name from sysobjects where xtype='U'

or

exec sp_tables

[dafu71]

select Name from sysobjects where xtype='U'
sp_tables
select * from Information_schema.tables

[netcoder]

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

[97866]

select name from sysobjects where xtype='U' and Status>0

[hjb111]

sp_tables


select name from sysobjects where xtype='U'