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
- 2040 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
If the job running very slow what is the action you do
Explain forward - only cursors?
How do you manipulate data?
What is the maximum size of a dimension? : sql server analysis services, ssas
How to find index size for each index on table?
How can we delete Duplicate row in table?
List some advantages and disadvantages of stored procedure?
What is bookmark link in ssrs?
What is indexing a document?
How can we check the sql server version?
How can we solve concurrency problems?
What is the function of inner join?
What is failover clustering overview?
What does Master database contains?
Why use stored procedures in sql server?
