Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How can I produce database documentation?
- Thread starter mohaimen
- Start date
MartinCroft
Programmer
You can use SQL Meta data found in the system tables
tables such as sysobjects, sysconstraints etc
use BOL and it will give you details on what these table hold. It not ideal to hit against these table repeatable, but you can take the data out into a datadictionary and then have regukar checks to update the data
tables such as sysobjects, sysconstraints etc
use BOL and it will give you details on what these table hold. It not ideal to hit against these table repeatable, but you can take the data out into a datadictionary and then have regukar checks to update the data
take a look at the information_schema ansi ssytem views all the information is there
Here are 3 to get you started
select * from information_schema.columns
select * from information_schema.tables
select * from information_schema.table_constraints
Denis The SQL Menace
SQL blog:
Personal Blog:
Here are 3 to get you started
select * from information_schema.columns
select * from information_schema.tables
select * from information_schema.table_constraints
Denis The SQL Menace
SQL blog:
Personal Blog:
- Status
Similar threads
- Locked
- Question
- Locked
- Question
