What is the diff between Truncate table / delete <table
name> purge
Answers were Sorted based on User's Feedback
Answer / murthy
TRUNCATE:-IT WILL DELETE ALL THE EXISTING RECORDS IN A TABLE
SYNTAX:-TRUNCATE TABLE <TABLE NAME>
DELETE:-IT WILL DELETE THE RECORDS IN A TABLE DEPENDINFG ON
THE GIVEN CONDITION.
SYNTAX:-DELETE FROM <TABLE NAME> WHERE <CONDITON>
PURGE:-AFTER PERFOMING DROP OPERATION THE TABLES WILL STORE
AT UNDO LOGS SO TO DELETE THE DATA COMPLETELY FROM TAHE
DATA BASE WE WILL PURGE THE RECYCLEBIN.
SYNTAX:-PURGE RECYCLEBIN.
Is This Answer Correct ? | 10 Yes | 4 No |
Answer / d.elumalai
DELETE:
1.DML Command.
2. Can be used with WHERE clause.
3. Can be rolled back.
4. Deletes table contents row by row when executed.
5. Delete is slow
6.Doesn't frees-up the Storage Space
7.Creates the log file
8.Returns the no. of rows deleted when queried.
9. Trigger gets fired incase of Delete.
10. Date gets copied into the Rollback tablespace after
Delete is executed.
TRUNCATE:
1.A DDL Command,
2.Can't be used with WHERE clause.
3.Can't be Rolled back.
4.Drops the entire table contents when executed but not the
table. [Note:DROP commnad deletes the entire contents along
with the table]
5.Truncate is faster.
6.Frees-up the Stroage Space
7. Doesn't create a log file
8.Doesn't return the no. of rows deleted when queried.
9.Trigger doesn't get fired incase of Truncate.
10.Data gets romoved directly without copying it into the
Rollback tablespace when truncate is executed.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / papia
Truncate table removes all rows from the table and alos
releases the storage space and as it is a DDL statement so
no Rollback information is available
Delete statement also removes the row but does not release
the storage space
Truncate is faster than delete.
Is This Answer Correct ? | 0 Yes | 1 No |
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
what is sql server agent? : Sql dba
Table Order_Name has a column Order_Date which gives the date & Time at which the order is passed.Find the table to write a query to find out the latest order.
Which version of sql do I have?
What does truncate mean in sql?
What are sql injection vulnerabilities?
Which nosql database is best?
define data blocks ? : Sql dba
What is the full form of sql?
What are different joins used in sql?
when is the use of update_statistics command? : Sql dba
What is the example of procedure?