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
- 2049 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 |
in the physical file layout, where should the transaction log be stored in relation to the data file?
What is inner join in sql server joins?
Explain query editor regions
which table keeps the locking information? : Sql server administration
How do you create an execution plan?
How many types of cursor type are there?
What is a periodical index?
Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)
How to use group functions in the select clause in ms sql server?
How can we get count of the number of records in a table?
How secure is sql server database?
Explain isolation levels that sql server supports?
-
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)
