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
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Database Structure
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

davidhydro
Starting Member

3 Posts

Posted - 10/07/2013 :  07:45:19  Show Profile  Reply with Quote
Hi All,

I have been requested to show the layout of a database within SQL2005. Having inherited the database from a previous administrator, whom inherited it from another the structure has never been recorded!

Is there a quick way I can get a layout of what Triggers, Relationships etc. are?

David

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 10/07/2013 :  07:51:28  Show Profile  Reply with Quote
you can using third party tools. But using standard client tools you can generate only database diagram not triggers etc objects. for that you need to query catalog views like sys.sql_modules etc

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

davidhydro
Starting Member

3 Posts

Posted - 10/14/2013 :  06:59:08  Show Profile  Reply with Quote
Hi,

Thanks for the reply, can you give me the name of a third party tool?

Best Regards

David
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 10/14/2013 :  07:09:46  Show Profile  Reply with Quote
There are a few in market like ApexSQL,Idera etc.

Serach in google and you'll get links for them

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
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.08 seconds. Powered By: Snitz Forums 2000