Interested to Buy Any Domain ? << Click Here >> for more details...
If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?
- 1 Answers
- 2103 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
Do you know what is replace and stuff function in sql server?
What are the acid properties?
Explain a checkpoint?
After removing a table from database, what other related objects have to be dropped explicitly?
What are group functions in query statements in ms sql server?
What is query cost in sql server?
How does recursive cte works in sql server?
How is sql used in sql server?
What is statement level trigger?
Explain about merge replications?
How to integrate the ssrs reports in application?
What is 5nf in normalization form?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
What is the Difference Between Primary and Foreign Key?
Can sql server 2016 run on windows 7?
