Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
anupalavila
Yak Posting Veteran
56 Posts |
 Posted - 2008-12-30 : 04:35:25
|
| Hi How can I list all the table names from my databaseThanks and Regards Anu Palavila |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-30 : 04:39:25
|
| [code]SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE'[/code] |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-30 : 04:41:04
|
or SELECT * FROM sysobjects where type='u' |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-12-30 : 05:11:45
|
| To include all tablesEXEC sp_tablesMadhivananFailing to plan is Planning to fail |
|
|
|
anupalavila
Yak Posting Veteran
56 Posts |
Posted - 2008-12-30 : 06:37:26
|
| Thanks to all for the valuable replayThanks and Regards Anu Palavila |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-30 : 06:45:35
|
| welcome |
|
|
|
|
|
|
How can I list all the table names from my databas