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!

Designing Database Schema

Status
Not open for further replies.

JUDGE27

MIS
Jul 20, 2002
47
AU
Hello,

Id like to know the simplest way to create a Database
Schema from within SQL Server, or techniques
to adopt.

Thanks in Advance.
 
SQL Server Enterprise Manager includes a diagramming tool. It isn't as good as ERwin or other full-featured ERD tools, but it is included. In SQL Server 2000, expand the Enterprise Manager tree to display the contents of the database. Right-click the Diagrams folder and select New Database Diagram from the pop-up menu to display the Create Databse Diagram Wizard's Welcome dialog box. Click the Next button to display a dialog box to select tables to add to the diagram. Click the Add related tables automatically check box. That should get you started.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top