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.