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

how to remove records from table?
no name
1 a
2 b
1 a
2 b
3 c

Answer Posted / krishna kum ar

delete <table_name> --------This removes only the records
not a tablespace

but

truncate <table_name>--------This removes both records as
well as tablespaces in database

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is sql easier than java?

1018


what is the difference between union and union all? : Sql dba

1021


How to run sql statements through the web interface?

1047


what are the advantages of sql ? : Sql dba

1060


What is full join?

961


What is pl sql code?

1056


What is composite data type in pl sql?

1118


What is clustered index in sql?

1054


What are the advantages of indexing?

986


Is sql port 1433 encrypted?

1029


what is query cache in mysql? : Sql dba

1040


What is sql lookup?

924


How do you truncate?

913


What are the constraints available in sql?

1049


how can you see all indexes defined for a table? : Sql dba

1000