SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Table flow
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

AskSQLTeam
Ask SQLTeam Question

USA
0 Posts

Posted - 10/03/2006 :  17:46:01  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
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
Flowing Fount of Yak Knowledge

Australia
1242 Posts

Posted - 10/03/2006 :  17:53:44  Show Profile  Visit timmy's Homepage  Reply with Quote
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.

Go to Top of Page

jezemine
Flowing Fount of Yak Knowledge

USA
2885 Posts

Posted - 10/03/2006 :  19:00:39  Show Profile  Visit jezemine's Homepage  Reply with Quote
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
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

Posted - 10/03/2006 :  22:30:28  Show Profile  Reply with Quote
You may find the script on this link useful for what you want.


Find Table Reference Levels
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72957




CODO ERGO SUM
Go to Top of Page

DonAtWork
Flowing Fount of Yak Knowledge

2161 Posts

Posted - 10/04/2006 :  10:47:26  Show Profile  Reply with Quote
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.aspx
Learn SQL
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp
Go to Top of Page

madhivanan
Premature Yak Congratulator

India
22744 Posts

Posted - 10/04/2006 :  10:59:41  Show Profile  Send madhivanan a Yahoo! Message  Reply with Quote
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

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000