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 the new features of SQL server 2000?

1 Answers  

What is the difference between index seek vs. Index scan?

0 Answers  

what are database files and filegroups? : Sql server database administration

0 Answers  

Explain about SQL server 2005?

0 Answers  

What are the differences between local and global temporary tables?

0 Answers  




What are Row versions of DataRow?

0 Answers  

Explain different types of lock modes in sql server 2000?

0 Answers  

how to get 25th row in any table in sqlserver can u tell me syntax

8 Answers  

How to Insert multiple rows with a single insert statement?

0 Answers  

What are the types of joins in sql?

0 Answers  

What are distributed partitioned views?

0 Answers  

What is index in an assignment?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories