If we drop a table, does it also drop related objects like constraints, indexes, columns, defaults, views, and stored procedures?
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 |
Explain what is analysis service repository?
Is it possible to create trigger on views?
what types of replication are supported in sql server? : Sql server database administration
How to stop log file growing too big?
what is a transaction and what are acid properties? : Sql server database administration
What are the advantages of the mirroring?
Where do you find the default Index fill factor and how to change it?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
Why we should not use triggers?
Please tell me some knowledge about Clustering and how to add clustering?
What is acid db?
Explain what is dbcc?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)