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 need of a partition key?

1027


What is the source code of a program?

1119


What does fetching a cursor do?

1133


What is the difference between local variables and global variables?

1174


What is pl/sql language case sensitive?

1181


How do I view a sql database?

1060


Why are cursors used?

1174


What is query optimization in sql?

1041


What are pl/sql packages?

1157


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

1081


What is the use of function "module procedure" in pl/sql?

1236


What is sql partition?

1162


what are sequences

1819


Can a primary key be a foreign key?

1079


Is sql free?

1025