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
- 1962 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 data warehousing in sql server?
Do you know what is xpath?
Explain the microsoft sql server delete command?
Does partitioning improve performance sql server?
What are various aggregate functions that are available?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
What is sql collation?
When is the use of update_statistics command?
What is save transaction and save point?
tell me the disaster recovery plan
How to convert numeric values to integers in ms sql server?
What is a trace frag?
What is bulkcopy in sql?
What is the command to change the recovery model?
How many types of stored procedures are there in sql server?
