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...

What is Difference Between delete and Truncate?

Answer Posted / udhayakumar

delete is used to delete one or more rows from the table
where as truncate to delete all the rows without its
structure from the table

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of count (*) in sql?

1054


how can we repair a mysql table? : Sql dba

981


What trigger means?

986


What is serial sql?

977


Why is pl sql used?

984


how tsql statements can be written and submitted to the database engine? : Transact sql

995


How to select random rows from a table?

1076


Does execute immediate commit?

1222


Which language is used in sql?

1061


Why plvtab is considered as the easiest way to access the pl/sql table?

1216


How do I run a script in sql developer?

951


What is query execution plan in sql?

1189


What are the sql versions?

952


What is primary key and unique key?

1121


How to check if a column is nullable before setting to nullable?

1128