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 |
|
turkish2
Starting Member
2 Posts |
 Posted - 2008-11-19 : 03:32:30
|
| hellohow can i get all tables name in the sever in all the databasesi see that there is sys.databases but not show all tables in my server is there any sql?thanksoren t |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2008-11-19 : 03:52:11
|
| select * from sys.objects where type = 'u' |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-19 : 10:18:51
|
| you can also use catalog view INFORMATION_SCHEMA.TABLES |
|
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2008-11-19 : 10:20:08
|
| --for sql 2000select * from sysobjects where xtype='u' |
|
|
|
|
|
|
tables in server