Interested to Buy Any Domain ? << Click Here >> for more details...
what is exact difference between drop and truncate table.
- 3 Answers
- 7239 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sowjanya
Drop Statement deletes the Table structure from the database.
Truncate statement will delete the entire data from Table
and keeps the Table structure as it is in the DB.
| Is This Answer Correct ? | 13 Yes | 0 No |
Answer / samad
ya its correct sowjanya
DROP - delete objects from the database
TRUNCATE - remove all records from a table, including all
spaces allocated for the records are removed in this
rollback is not possible
DELETE - deletes all records from a table, the space for the
records remain rollback is possible
| Is This Answer Correct ? | 13 Yes | 0 No |
Answer / chandana
Drop :
1.Deletes the entire table records as well as the table
structure.
2.It is a DDL Command.
3. Logs are not maintained.
4. Auto Commited.
5.Where clause cannot be used in the Drop statement.Synatx:
Drop table <Table_Name>
Trunctae:
1. Deletes the entire table records ,retains the table
structure.
2. Its a DDL Command.
3. Logs are not maintained. So faster in performace than
Delete.
4. Auto Commited.
Cannot be Rolled Back.
5.Where clause cannot be used with truncate statement.
Truncate Table <Table_Name>;
Delete:
1. Deletes the table records based on condtions ,retains
the table structure.
2. Its a DML Command.
3. Logs are maintained.So slower than trucate.
4. No Auto Commited.So can be Rolled Back.
5.Where clause can be used with truncate statement.
Syantx:
Delete from <Table_Name> where <Condition>;
| Is This Answer Correct ? | 5 Yes | 0 No |
what is the difference between authorization and authentication?
5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.
How to execute a stored procedure in oracle?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
what is IDE,DMV in sql server?
How to pass parameters to procedures in oracle?
When a form is invoked with call_form, Does oracle forms issues a save point ?
Explain the concept of the DUAL table.
SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?
Tell me New Feature of Oracle 10g?
Explain the use of constraints option in exp command.
How do I call oracle stored procedures that take no parameters?
Oracle General 
