Print SQL server 2000 database structure

How do I able to print out each table its column name, datatype as well as the dependency?

Anyone one have any SQL script that will allow me to extract the information?

Thanks
tommym121Asked:
Who is Participating?
 
Rajkumar GsConnect With a Mentor Software EngineerCommented:
Try this query
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
ORDER BY ORDINAL_POSITION

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.