What is the diff between Truncate table / delete <table
name> purge
- 3 Answers
- 14353 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is not in sql?
what is union? : Sql dba
How do I start sql profiler?
Is join an inner join?
how many tables will create when we create table, what are they? : Sql dba
Why schema is used in sql?
What is the source code of a program?
What is native sql query?
Can sql function call stored procedure?
How do I trace sql profiler?
How many sql core licenses do I need?
How do I find sql profiler?
What is gpt format?
what are myisam tables? : Sql dba
How do I view a table in sql?
