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
- 1975 Views
- I also Faced
- E-Mail Answers
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 |
How to drop an existing stored procedure in ms sql server?
how would you improve etl (extract, transform, load) throughput?
What are different types of collation sensitivity?
What is sql sandbox in sql server?
How to concatenate two binary strings together?
Why use triggers?
What is openrowset sql server?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
What is the importance of three tier architecture?
What does dml stand for?
What is the difference between Userdefined function and stored procedure? Explain and give the example also
-
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)
