1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?

Question Posted / maheswari


If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, ..

Answer / 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

More SQL Server Interview Questions

explain different types of cursors? : Sql server database administration

0 Answers  

What are database states in ms sql server?

0 Answers  

Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

0 Answers  

What is SubQuery in SQL Server 2008

0 Answers   HCL,

Explain filtered indexes benefits?

0 Answers  




CTE(common table expression)

1 Answers   Thomson Reuters,

What is faster join or union?

0 Answers  

How do I find the size of a sql server database?

0 Answers  

Why Master database is required?

0 Answers   Abacus,

How can you get @@error and @@rowcount at the same time?

9 Answers  

How to get number of days in a given year?

4 Answers   ADP,

What is the use of DBCC commands?

4 Answers   NA,

For more SQL Server Interview Questions Click Here
Categories