Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What is difference between TRUNCATE & DELETE?

Question Posted / rr

Answer Posted / rr

delete command delete the rows from table record by record but truncate removes all the records is nothing but it drops the table and creates table structure as it is

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How much does sqlite cost?

982

What are the types of variable use in pl sql?

1006

What are few of the schema objects that are created using PL/SQL?

965

What is date functions?

958

what are the join types in tsql? : Transact sql

980

What are predefined functions in sql?

976

What are the different ways to optimize a sql query?

888

What are the different types of dbmss?

960

Explain ttitle and btitle.

1056

write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

915

how many sql ddl commands are supported by 'mysql'? : Sql dba

953

what is transaction? : Sql dba

958

Why is stored procedure faster than query?

906

how to write date and time literals? : Sql dba

912

What is the sql*loader? : aql loader

1003