This question is locked. New answers and comments are not allowed.
Hello,
How can I delete a table in the ORM Visual Designer in the Model Schema Explorer? I want to delete there and then Update Database from Model in order to drop table in Database. I deleted the mapped Entity Set, but I can't delete the table.
Thanks in advance.
How can I delete a table in the ORM Visual Designer in the Model Schema Explorer? I want to delete there and then Update Database from Model in order to drop table in Database. I deleted the mapped Entity Set, but I can't delete the table.
Thanks in advance.
1 Answer, 1 is accepted
0
Accepted
Hi Iván Tajes,
We do not provide an option to drop tables through the Update Database from Model wizard. It is not a feature that we want to support because we are destroying relational data. You can modify and create new tables but you cannot drop them directly with OpenAccess. The way to remove a table from the Model Schema Explorer is to drop the table in the database, run the Update From Database wizard and apply the "Remove" change for the dropped table. So, to actually drop the table you will need to use another tool such as SQL Server Management Studio.
Feel free to contact us, if you have any further questions.
All the best,
Petko_I
the Telerik team
We do not provide an option to drop tables through the Update Database from Model wizard. It is not a feature that we want to support because we are destroying relational data. You can modify and create new tables but you cannot drop them directly with OpenAccess. The way to remove a table from the Model Schema Explorer is to drop the table in the database, run the Update From Database wizard and apply the "Remove" change for the dropped table. So, to actually drop the table you will need to use another tool such as SQL Server Management Studio.
Feel free to contact us, if you have any further questions.
All the best,
Petko_I
the Telerik team