Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-12-12 : 07:31:01
|
| writes "how to delete a table" |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-12-12 : 07:37:30
|
| Drop table table-name.Make sure to take backup before doing this.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-12 : 07:42:21
|
| OrTRUNCATE TABLE <YourTableNameHere>Peter LarssonHelsingborg, Sweden |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-12-12 : 07:46:29
|
| Peter, If OP has written it correctly, OP wants to delete table not the data, although his terminology is incorrect.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-12 : 07:51:19
|
| Yes.But both you and I have been here long enough to realize that OPs not often knows what he/she wants, nor the proper way to express his/hers objectives.Peter LarssonHelsingborg, Sweden |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-12-12 : 11:32:40
|
quote:
Originally posted by AskSQLTeam
writes "how to delete a table"
1 You should Learn SQLhttp://www.sql-tutorial.net/ http://www.firstsql.com/tutor.htm http://www.w3schools.com/sql/default.asp 2 If you dont know how to delete a table, better keep away from DELETE3 Google is always your friendMadhivananFailing to plan is Planning to fail |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-12-12 : 11:33:59
|
| anyway, what is OP?MadhivananFailing to plan is Planning to fail |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-12-12 : 12:21:38
|
| OP = Original Poster.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-12-13 : 10:37:52
|
quote:
Originally posted by harsh_athalye
OP = Original Poster.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED"
 MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
delete