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
- 2033 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
Does sql server 2000 clustering support load balancing?
How to replace null values in expressions using isnull()?
How can sql injection be stopped? : sql server security
What are subquery and its properties?
Does a specific recovery model need to be used for a replicated database? : sql server replication
Differentiate between ms sql server reporting services vs crystal reports?
Can we use where and having clause together?
What is importing utility?
What are the different acid properties?
What is outer join in sql server joins?
What are the differences between char and varchar in ms sql server?
Explain system rowset functions?
How many types of built in functions are there in sql server 2012?
What is the use of stored procedure?
What the class forname () does?
