Clever Geek Handbook

Creating sql chart

I have installed SQL Server 2005 and I want to create a database, but I cannot. When I right click on the Diagrams database folder for my database in SQL Server Management Studio 2005, I don't see any choice for creating a database diagram. I see two things:

  • Working with sql server 2000 charts
  • Refresh
+2


source to share


4 answers


The ERD diagram generated by the wizard in SQL Server Management Studio is a physical ERD, not a logical one. It doesn't seem like using Oracle Designer ...



First you need to create a table and link as needed. After defining at least one table, it becomes possible to create a database diagram.

+2


source


I have tried this in the past and tried it again after seeing this post. Here is my experience with SQL 2005 Management Studio (connected to SQL Server 2005):



  • If you create an empty database (no tables) and click "Database Diagrams", you will be prompted, "This database does not have the objects required to create database diagrams. Do you want to create them?"

  • If your answer is yes, you can right click on the "Database Diagrams" node and click on "New Database Diagram". By default, the command line displays Add Table. This is good if you already have tables and want to add them to your chart. However, it only gives the "Refresh" option. The add button, although present, is disabled (we don't have tables yet).

  • Now, to create a table, you can close the "Add Table" dialog and right-click in the right pane and click "New Table"

  • In this case, the process of creating a table is intuitive. When you save the chart, the table is created in the database.

+1


source


Expand the folder, it should ask to install objects. Then you can add charts.

0


source


First, you have to create tables, write scripts without using a graphical interface.

The symptoms you describe indicate that the database was created as a SQL Server 2000 database and therefore you cannot use the 2005 SSMS Chart Creator. If you think you need to do it with a diagram instead of a script, then you should use Enterprise Manager. If you clicked on the option 1.Working with SQL Server 2000 Diagrams, then SQl Server would tell you so.

0


source






More articles:


All Articles