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 the difference between TRUNCATE and DELETE command
in SQL

Answer Posted / sathya

I just wanna add a point ..

while truncating a table both the structure and the datas will be removed. where as in Delete structure of the table ramains only the data in the table will be deleted.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2521


what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

2216


I need a Technical evaluation between Oracle and SAP ? please do a need ful.

1994


difference of using cursor for loop and open,fetch,close.which one is better

1805


What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

1159


What view would you use to determine free space in a tablespace?

2224


Explain the process of recievables in oracle financials. : oracle accounts receivable

1155


how to write customizations in po

1618


how can we add a field to the oracle standard forms through Form Persanlization or custom.pll

2399


Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

1294


Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

1276


PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2220


please send me oracle pl/sql exp resume. and also faqs...

2494


what is difference between inner join & nested query or subqueries

3034


CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

2073