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

write down the code for "how we delete a table without
using of Drop command " ?

Answer Posted / bhagwat sharma

table delete only by
drop table (tablename)

if you want do delete all data from table than you wil use
command

truncate table (tablename)

this command don't delete table delete only table data ok

Is This Answer Correct ?    16 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between varchar and varchar types?

1068


What is normalization and denormalization in sql server?

1001


Explain syntax for viewing, dropping and disabling triggers?

944


What are the types of normalization?

1024


what is database replication? : Sql server database administration

1050


What are three major types of constraints?

1105


Explain isolation levels that sql server supports?

1027


Why transaction is important?

968


What is the language structure to add a record to a table?

1021


What are the components of dbms?

948


Which command is used for user defined error messages?

1058


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

2471


How do I schedule a sql server profiler trace?

968


what stored procedure would you use to view lock information? : Sql server administration

962


What is difference between rollback immediate and with no_wait during alter database?

1081