如何利用SQL语句查询数据库中所有表的名称？

[yinzs]

如何利用SQL语句查询数据库中所有表的名称？
有没有这种语句？

[水族杰纶]

[Quote=引用 7 楼 lgxyz 的回复:]
SQL codeselect * from sysobjects where xtype='U'
[/Quote]

[fcuandy]

[Quote=引用 1 楼 roy_88 的回复:]
SQL codeuse test--數據庫名
go
select * from sysobjects where xtype='U'
[/Quote]

[cxmcxm]

select * from sysobjects where type='U'

[rhq12345]

select * from sysobjects where xtype='U'

[linguojin11]

[Quote=引用 1 楼 roy_88 的回复:]
SQL codeuse test--數據庫名
go
select * from sysobjects where xtype='U'
[/Quote]

[tongxinfeixiang]

select * from sysobjects where xtype = 'u'

[hyde100]

select * from sys.objects where type ='U'

[三下鱼]

select * from sysobjects where xtype='U'

[ws_hgo]

select * from sys.objects where xtype ='U'

[cxmcxm]

select * from sysobjects where type='U'

[sydee]

select * from sysobjects

[ivan_ren]

select * from sysobjects where xtype='U'

[kofken]

select name from sysobjects where type='U'

[mskyp]

select * from sysobjects where xtype='U'

[LIHY70]

select * from sysobjects where xtype='U'

[wgzaaa]

--用这个也是可以的，但不如前面大多数人提到的简单：sp_tables @table_type ='''TABLE'''
--只取表名
create table #a(a varchar(50),b varchar(50),c varchar(100),d varchar(50),e varchar(50))
insert #A exec sp_tables @table_type ='''TABLE'''
select c name from #a

[germliucaixia]

select * from sysobjects where xtype='U'

[hai521]

select * from sysobjects where xtype='U'

[junyao100]

不错……………………回帖，加分

[一路遥遥]

select * from sysobjects where xtype='U'为什么说找不到database？菜鸟了