If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?
Answer Posted / anusha
No, dropping the table does not delete the corresponding table objects. Need to drop Indexes, views first before dropping the table.
eg:
drop view <database name>.<view name>
alter table <database name>.<table name> drop <index type>
drop table <database name>.<table name>
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can you explain about buffer cash and log cache in sql server?
What is the difference between Clustered and Non-Clustered Index?
Define self join in sql server joins?
What are the characteristics of modern DBMS?
What does the update command do?
Benefits of Stored Procedures?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
Explain the properties of a relational table?
Is truncate a dml command?
How check triggers in sql server?
List all the types of user-defined functions?
Find nth lowest salary or get nth lowest salary?
How can we use ConnectorJ JDBC Driver with MS SQL?
Does partitioning ssd reduce performance?
What is not null constraint?