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 |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2009-09-29 : 04:49:09
|
| Dear All,Recently i was allocated to project on SQL server database.The project having single database with 430 tables but there is no document for the details.I was assigned to document all the tables (Column Name,DataType,Size) and Primary key & foreign key and Identity key means relation between tha tables.Can you please help me to get all tese details as there are 430 tables are there.I tried to Do it by using sp_help 'tablename' but it is taking a lotof time also not getting exact relation betwwen the tables.Pls help me in this regard..also if somebody send the sample database design document to my mail id ms.gangadhar@gmail.com it wil be really helpfull for me.Thanks In advance Gangadhar |
|
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
Posted - 2009-09-29 : 08:29:54
|
| All,Please give me some hints how can i fetch the mentioned details from the DB. |
 |
|
|
swatip
Starting Member
8 Posts |
Posted - 2009-09-30 : 05:51:39
|
| Hi,Just go to the SQL redgate tool website and download their SQL DOC tool trial version.This tool will help you to document the SQL server database.It will give you all details including object dependancies. |
|
|
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
Posted - 2009-09-30 : 12:19:35
|
| Hi Swatip,Thanks for the Reply..But when i try to download the free version of the software it asks mail id and password but there is no option for me to Sign Up as a new user.Can u pls guide me how to Sign Up to download the 14 days trial version.Thanks Gangadhar |
|
|
|
swatip
Starting Member
8 Posts |
Posted - 2009-10-01 : 02:35:07
|
| You need not sign up in the redgate website .Just mention your email address and pwd after which it will ask you to download the tool. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-01 : 02:57:35
|
| you could also use catalog views for getting this info like information_schema.columns,sys.key_constraints,sys.foreign_keys,sys.identity_columns,... |
|
|
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
Posted - 2009-10-01 : 06:28:23
|
| Dear All,Thanks a lot Swatip for your help it really saves my 2 days of work.Thanks a lot it the tools are really awaresome.ThanksGangadhar |
|
|
|
|
|
|
Data Base Design Documrnt