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 |
|
Nitin Bansal
Starting Member
13 Posts |
 Posted - 2008-06-12 : 03:47:13
|
| Hi to All,I want to know a query by which i can get the whole structure of my DataBase -eg. it should give me all table names and structure which exists in this particular database .....Thanks |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-06-12 : 03:53:19
|
| Right click on the database -> Tasks -> Generate SQL Scripts.. |
 |
|
|
Nitin Bansal
Starting Member
13 Posts |
Posted - 2008-06-12 : 03:55:34
|
| I asked for a query ............. |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-06-12 : 03:57:24
|
| Run the above with profiler on and you will get the internals used. There is no query as such. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-12 : 23:13:36
|
| Did you try what RickD has said? |
|
|
|
|
|
|
Whats the Query for Describe a database