Lost Password?


Go Back   CodeCall Programming Forum > Web Development Forum > Database & Database Programming
Reload this Page Erase everything in a table
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Database & Database Programming MySQL, Oracle, SQL, PL/SQL, ABAP, Smart Forms, and other databases and languages. A database is an organized body of related information used in many websites (including CC).

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-08-2006, 03:22 PM
Paradine Paradine is offline
Learning Programmer
  
Join Date: Oct 2006
Posts: 48
Rep Power: 8
Paradine is on a distinguished road
Default Erase everything in a table
I can't remember how to erase everything in a table. Anyone know real quick?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

Sponsored Links
  #2 (permalink)  
Old 11-09-2006, 12:39 PM
WingedPanther's Avatar   
WingedPanther WingedPanther is offline
Super Moderator
  
Join Date: Jul 2006
Age: 35
Posts: 3,276
Last Blog:
wxWidgets is NOT code ...
Rep Power: 36
WingedPanther is a name known to allWingedPanther is a name known to allWingedPanther is a name known to allWingedPanther is a name known to allWingedPanther is a name known to allWingedPanther is a name known to all
Default
DELETE FROM table_name
__________________
CodeCall Blog | CodeCall Wiki | Shareware | Linux Forum
Programming is a branch of mathematics.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 11-09-2006, 01:06 PM
Jordan's Avatar   
Jordan Jordan is offline
Administrator
  
Join Date: Nov 2005
Location: Hendersonville, NC
Posts: 9,224
Last Blog:
Ext JS or Ext GWT
Rep Power: 20
Jordan is just really niceJordan is just really niceJordan is just really niceJordan is just really nice
Send a message via ICQ to Jordan Send a message via AIM to Jordan Send a message via MSN to Jordan
Default
Or you could use

TRUNCATE [TABLE] tbl_name

as well
__________________
CodeCall Blog | CodeCall Wiki | Shareware Site | Linux Forum | Write a Blog
The CodeCall Wiki is now fully integrated with vBulletin users! Check it out and add some new pages!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 11-12-2006, 02:32 PM
Paradine Paradine is offline
Learning Programmer
  
Join Date: Oct 2006
Posts: 48
Rep Power: 8
Paradine is on a distinguished road
Default
That works, thank you!

How do I delete all of the tables from a database now?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 11-12-2006, 08:03 PM
Jimbo Jimbo is offline
Programmer
  
Join Date: Jul 2006
Posts: 121
Rep Power: 9
Jimbo is on a distinguished road
Default
Not 100% but I think its 'DROP tablename'
__________________
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

Sponsored Links
  #6 (permalink)  
Old 11-20-2006, 11:05 AM
Lop's Avatar   
Lop Lop is offline
Speaks fluent binary
  
Join Date: May 2006
Posts: 1,149
Rep Power: 18
Lop will become famous soon enoughLop will become famous soon enough
Default
Quote:
Originally Posted by Jimbo View Post
Not 100% but I think its 'DROP tablename'
That is correct.
__________________
Lop
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« Previous Thread | Next Thread »


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ODBC API - Special Table and Column Names Tronman Database & Database Programming 0 07-30-2007 01:52 PM
Create temporary table in VB6 lfc1211 Visual Basic Programming 3 05-11-2007 05:29 PM
Adding a calculated column to a table reachpradeep Database & Database Programming 0 03-05-2007 08:13 AM
Flex, bison multifunction calculator annatsos C and C++ 1 01-04-2007 07:00 AM
Working with TADO Table MrDiaz Pascal/Delphi 0 07-03-2006 07:28 PM


All times are GMT -5. The time now is 12:11 PM.

Contact Us - Programming Forum - Archive - Top

CodeCall

Contest Stats

WingedPanther ........ 2753.6
Xav ........ 2704
Brandon W ........ 1702.32
John ........ 1207.73
marwex89 ........ 1175.24
morefood2001 ........ 966.05
dcs ........ 655.75
Steve.L ........ 475.59
orjan ........ 418.58
Aereshaa ........ 383.54

Contest Rules

CodeCall Goal

Goal: 100,000 Posts
Complete: 98%

Sponsors

Linux Forums
Electronic Music
Podnet IRC Network

Ads