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

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / shanmugam

Answer Posted / shanmugam

truncate table tablename

Is This Answer Correct ?    7 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you think of this implementation? Can this be implemented better?

994

What is checkpoint in sql server?

1214

You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

2185

Explain about extended stored procedure?

991

Do you know what is openxml in sql server?

1113

Where to find ntwdblib.dll version 2000.80.194.0?

1007

Which sql server is best?

1047

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

937

How do I delete a sql server database?

1096

What is user-defined inline table-valued function?

1003

Explain transaction server consistency?

1017

What is replace and stuff function in sql server?

1111

How to backup SQL Server Reporting Services ?

152

What does asynchronous call backs means?

1223

How to create user defined functions with parameters?

1293