If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?
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
What does it mean to be in union?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
What is proper subset of candidate key?
Explain left outer join and right outer join?
What is the optimization being performed in oracle and SQL Server?
explain different types of backups avaialabe in sql server? : Sql server database administration
What are cursors stored procedures and triggers?
What is sql server 2000 work load governor?
How to how to convert numeric expression data types using the convert() function??
How to get the definition of a view out of the sql server?
How display code or Text of Stored Procedure using Sql query in Sql Server ?
What is use of dbcc commands?
What is updatable resultset?
Do you know what is openxml in sql server?
Are null values the same as that of zero or a blank space?