If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?
- 1 Answers
- 1657 Views
- I also Faced
- E-Mail Answers
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
Explain can you implement data mining in ssrs?
Can you create a logon trigger in sql server 2005 express edition?
What is difference between index seek vs. Index scan?
What are a scheduled jobs?
What is cte (common table expression)?
Can you explain what is sql server english query?
Why do we backup Active Directory ?
What are the restrictions that views have to follow? : SQL Server Architecture
How efficient you are in oracle and SQL server?
What is co-related sub query?
What are examples of triggers?
If we delete pack Spec what will be the status of pack Body ?
what is raid and what are different types of raid configurations? : Sql server database administration
What are the joins in sql server? : sql server database administration
What happens to a statement batch if there is a compilation error?
