What is the diff between Truncate table / delete <table
name> purge
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 an implicit commit?
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
Why use stored procedures?
What is the purpose of normalization?
State some properties of relational databases?
What is difference between nchar and nvarchar?
How delete all data from all tables in sql?
How do you create a db file?
How do I trace sql profiler?
What is use of trigger?
how can we optimize or increase the speed of a mysql select query? : Sql dba
What is posting?
what are the authentication modes in sql server? How can it be changed? : Sql dba
Is progress software supports to ( pl/sql )?
What is parameter substitution in sql?