When you delete a table,its strututral definition,data,indexes,views,constraints are permanently deleted from a database?
-
When you delete a table,its strututral definition,data,indexes,views,constraints are permanently deleted from a database? srushti08
Yes, usually... In SQL Server, you can setup a 'View' in such a way that it prevents a participating table from being deleted...I think! Unless you store the schema of a table in some other way, the structural definition will be lost too. Steve
-
When you delete a table,its strututral definition,data,indexes,views,constraints are permanently deleted from a database? srushti08
If you use "drop table", yes. If what you really want to do is just remove all the data, you should use "truncate table..."
-
When you delete a table,its strututral definition,data,indexes,views,constraints are permanently deleted from a database? srushti08
Sounds like a school question. All data and schemas are deleted, however views won't be removed, you may get a warning however and the delete won't work if you have SCHEMABINDING in your views. Constraints will stop the delete working too, so they'll need to be removed from other questions. Try deleting a table, that's the easiest way to find out.