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 |
|
Surfer513
Starting Member
29 Posts |
 Posted - 2011-12-30 : 23:59:28
|
| I'm looking to be able to create a database diagram without actually creating database objects. It seems like the best way to do this would be directly through SSMS. My only question is, is there a way to not have SSMS create the database objects when you create them in the database diagram?I want this as a planning and design tool, not necessarily for implementation yet. I just want to lay it all out without actually creating any tables yet. When I am in the Database Diagram and click New Table, I just want it to create the new table to be used in the diagram as opposed to a table database object being created in the database. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2011-12-31 : 01:49:12
|
| You can't do that, but you can create an empty "design" database and create the database objects there.CODO ERGO SUM |
 |
|
|
Surfer513
Starting Member
29 Posts |
Posted - 2011-12-31 : 02:02:49
|
| Ok, thanks for the help! |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-12-31 : 02:40:52
|
| You can do that by creating a logical model with VS 2010 and then actually create the objects in the database from that logical model.PBUH |
|
|
|
BruceT
Yak Posting Veteran
78 Posts |
Posted - 2012-01-09 : 14:58:50
|
| There are also several modeling tools out there that let you create the ERD's and if you want generate the database creation scripts at the touch of a button. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Surfer513
Starting Member
29 Posts |
Posted - 2012-01-10 : 08:15:02
|
| Do I have the DDL? I mean, sure after the objects are created I can always generate the scripts for them. |
|
|
|
Sachin.Nand
2937 Posts |
|
|
|
|
|
Create Database Diagrams but not Database Objects