Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diff between Truncate table / delete <table
name> purge
- 3 Answers
- 15711 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 are stored procedures used for?
What is a database trigger?
Why use stored procedures?
What is case function?
Explain alias in sql?
How many postgresql users are there, worldwide?
how can we optimize or increase the speed of a mysql select query? : Sql dba
What is an invalid partition table?
What is normalisation and its types?
What are the properties of a transaction?
What is the least restrictive isolation level? : Transact sql
what is an extent ? : Sql dba
What is the difference between joins?
What are the types of sql commands?
How do I upgrade sql?
