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 |
|
boreddy
Posting Yak Master
172 Posts |
 Posted - 2008-08-05 : 09:03:49
|
| how can get tables list from databes by writing query |
|
|
suresha_b
Yak Posting Veteran
82 Posts |
Posted - 2008-08-05 : 09:09:16
|
| SELECT * FROM SYS.TABLES |
 |
|
|
boreddy
Posting Yak Master
172 Posts |
Posted - 2008-08-05 : 09:10:04
|
| In my sever i have many databesesi need to get the all tables list and column datatypesof tables for pertuculat databes how can i get that list by writing query |
|
|
|
suresha_b
Yak Posting Veteran
82 Posts |
Posted - 2008-08-05 : 09:15:30
|
| exec dbo.sp_MSforeachdb "use ?;SELECT * FROM SYS.TABLES" |
|
|
|
|
|
|
how