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
- 2020 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
How can you manage sql azure security?
What is the difference between varchar and varchar types?
What is the recovery model? List the types of recovery model available in sql server?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
can any body tell me how to know the password of current user in sql server
Can you always create a cache of a report?
What do you understand by physical_only option in dbcc checkdb?
do you know how to configure db2 side of the application? : Sql server database administration
What is correlated subquery in sql server?
Explain what role entity and relationship play in an ER diagram.
User wants only to display only pdf as export option in report manager. How to achieve this?
How many replicas are maintained for each SQL Azure database?
How to check parameter value in stored procedure sql server?
How can we migrate from SQL server to SQL Azure?
What are the recovery models for a database?
