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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-10-03 : 17:46:01
|
| Premnath writes "How do i find the order of my Tables in my database? I need to populate them from the beginning. As i have 600 tables in my database how do i find out its order." |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-10-03 : 17:53:44
|
| Why does the ordering of your tables matter?Or are you talking foreign key constraints and the like? If so, you need to know the structure of your database. |
 |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2006-10-03 : 19:00:39
|
| I wrote a shareware app called sqlspec that might be able to help you. It will show you diagrams for how your tables relate to one another, as well as lots of other inforamation about your database.The link to it is in my sig below.SqlSpec - a fast, cheap, and comprehensive data dictionary generator for SQL Server 2000 and 2005 - http://www.elsasoft.org |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2006-10-04 : 10:47:26
|
| This post smells of "Plug my software" rather pungently.[Signature]For fast help, follow this link:http://weblogs.sqlteam.com/brettk/archive/2005/05/25.aspxLearn SQLhttp://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-10-04 : 10:59:41
|
quote:
Originally posted by AskSQLTeam
Premnath writes "How do i find the order of my Tables in my database? I need to populate them from the beginning. As i have 600 tables in my database how do i find out its order."
Define the Order  MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Table flow