Generate table relationship diagram from existing schema (SQL Server) [closed]

by

Yes you can use SQL Server 2008 itself but you need to install SQL Server Management Studio Express (if not installed ) . Just right Click on Database Diagrams and create new diagram. Select the exisiting tables and if you have specified the references in your tables properly. You will be able to see the complete diagram of selected tables.
For further reference see Getting started with SQL Server database diagrams

More Related Contents:

  1. Updating image in VB and SQL Server not working [closed]
  2. Query to list number of records in each table in a database
  3. Storing a file in a database as opposed to the file system?
  4. Multiple Indexes vs Multi-Column Indexes
  5. Preferred Method of Storing Passwords In Database
  6. Using a sort order column in a database table
  7. Create a view with ORDER BY clause
  8. What does ‘COLLATE SQL_Latin1_General_CP1_CI_AS’ do?
  9. How to do version control for SQL Server database?
  10. What columns generally make good indexes?
  11. How to determine total number of open/active connections in ms sql server 2005
  12. How to check if a database exists in SQL Server?
  13. Getting execute permission to xp_cmdshell
  14. TSQL: Create a view that accesses multiple databases
  15. How to migrate a PostgreSQL database into a SQLServer one?
  16. What is the point of “Initial Catalog” in a SQL Server connection string?
  17. “Cannot open user default database. Login failed.” after installing SQL Server Management Studio Express
  18. How to create a yes/no boolean field in SQL server?
  19. Best way to store time (hh:mm) in a database
  20. How can I run just the statement my cursor is on in SQL Server Management Studio?
  21. Executing set of SQL queries using batch file?
  22. Database design: Calculating the Account Balance
  23. In SQL Server, how can I lock a single row in a way similar to Oracle’s “SELECT FOR UPDATE WAIT”?
  24. Date range overlapping check constraint
  25. What are the advantages of VistaDB
  26. Difference between database and schema
  27. Calculate Time Difference Between Two Rows
  28. What are the limitations to SQL Server Compact? (Or – how does one choose a database to use on MS platforms?)
  29. How do you deal with blank spaces in column names in SQL Server?
  30. Tool for Scripting Table Data

Leave a Comment