When right click on an entity in ER Diagram in Toad for SQL Server, there are options to Create Table, Create Table Like, Alter Table, Drop Table etc. When performing any of these options, the corresponding changes are made to the ER diagrams and the database structure immediately. Is it possible to perform data modeling using ER Diagram and not affect the database structure?
The options to Create Table, Create Table Like, Alter Table, Drop Table are not for data modeling. These are database administration options which will effectively modify the tables / database accordingly.
The ER Diagram is not met for data modeling.
Toad Data Modeler is the best solution for ER Diagram modeling, reporting, documentation. The ER Diagram in Toad for SQL Server is only a small subset of what Toad Data Modeler can offer.