| Author |
Topic |
|
kid_on_the_block
Posting Yak Master
172 Posts |
 Posted - 2006-02-16 : 00:03:58
|
| Hi I need to document all the tables & the fields of it & the data type , the PK & FK keys & all that Can anyone suggest the fastest method to get all the data , or some link on how the format should be Please help |
|
|
shallu1_gupta
Constraint Violating Yak Guru
394 Posts |
Posted - 2006-02-16 : 00:19:54
|
| Hi,you can use Enterprise Manager to generate the script of all the tables (including indexes, PKs,FKs and other constraints etc) |
 |
|
|
kid_on_the_block
Posting Yak Master
172 Posts |
Posted - 2006-02-16 : 00:24:20
|
| hmm , am not sure what you mean by that , I dont want to create scripts of the DB , I want info abt the DB (Data Dictionary ) I mean some kind of documentation for the DB Thanks |
|
|
|
shallu1_gupta
Constraint Violating Yak Guru
394 Posts |
|
|
kid_on_the_block
Posting Yak Master
172 Posts |
Posted - 2006-02-16 : 02:04:16
|
| Is there any free tool available to document the SQL Server |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2006-02-16 : 03:23:31
|
| try one of these[url]http://www.google.co.uk/search?sourceid=navclient&ie=UTF-8&rls=GGLG,GGLG:2005-38,GGLG:en&q=document+sql+server+database[/url]steve-----------Oh, so they have internet on computers now! |
|
|
|
shallu1_gupta
Constraint Violating Yak Guru
394 Posts |
Posted - 2006-02-16 : 03:28:28
|
| Search for DBDesigner. I think its a Freeware |
|
|
|
kid_on_the_block
Posting Yak Master
172 Posts |
Posted - 2006-02-16 : 04:35:45
|
| Thanks |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-02-16 : 05:06:12
|
| Slightly at a tangent, but if you use the Table Description and Column Description, in Enterprise Manager, you will a) have descriptive details for anyone who accesses the tables and b) be able to report on that.For what you need a couple of fairly simple queries on INFORMATION_SCHEMA.COLUMNS (and TABLES, TABLE_CONSTRAINTS and maybe VIEWS) will probably give you what you need.Kristen |
|
|
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
Posted - 2006-02-16 : 11:09:57
|
| Like Steve suggests if you Google related subjects you'll find others have written scripts to do this. |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2006-10-28 : 11:57:59
|
I know this an old thread, but I just have to add my baby to the mix: SqlSpec is an app I wrote to do this. It has very good reviews, and is very cheap. Trial version is fully featured, and has no expiration. Link is in my sig below.
SqlSpec - a fast, cheap, and comprehensive data dictionary generator forSQL Server 2000/2005 and Analysis Server 2005 - http://www.elsasoft.org |
|
|
|
DonAtWork
Master Smack Fu Yak Hacker
2167 Posts |
Posted - 2006-10-30 : 08:24:05
|
| Resurrecting old threads is a no no. It is not helping anyone 9 months after the fact of their question.[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 |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2006-10-30 : 09:54:38
|
fair enough, won't happen again.
SqlSpec - a fast, cheap, and comprehensive data dictionary generator forSQL Server 2000/2005 and Analysis Server 2005 - http://www.elsasoft.org |
|
|
|
vxx
Starting Member
1 Post |
Posted - 2008-06-20 : 13:22:12
|
| No, there is nothing wrong with posting a reply 9 months later.People are still looking at this entry and may benefit. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-20 : 13:33:02
|
| Yeah. Somebody might still benefit from this. |
|
|
|
DavvaHill
Starting Member
1 Post |
Posted - 2009-06-30 : 10:20:12
|
| 9 months/2 years, what's the difference? If someone has something to enhance the answer and the topic is still searchable - then crack on. I've just found this useful, so nice one. |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2009-06-30 : 10:27:01
|
+ nice plug jez.  Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
|
Data Dictionary