SQLCourse - Lesson 8: Drop a Table

The Wayback Machine - https://web.archive.org/web/20071011021522/http://sqlcourse.com:80/drop.html

Internet.com - The Network for Technology Professionals

Events
- JupiterEvents
- JupiterWebcasts
Jobs
Partners
Solutions
- eBooks
- Video
Shop

Free Newsletters:
	DatabaseJournal
	DBANews

Interactive Online SQL Training

SQL Courses

1	What is SQL?
2	Table basics
3	Selecting data
4	Creating tables
5	Inserting into a table
6	Updating records
7	Deleting records
8	Drop a table
9	Advanced Queries
10	Standalone SQL interpreter
11	Advertise on SQLCourse.com
12	Database Links
13	Technology Jobs

internet.commerce

Partner With Us
Dental Insurance
Mp3 Player Reviews
Online Education
Baby Photo Contest
Contemporary Art
Promotional Gifts
Auto Insurance Quote
Mortgage Refinance
Web Design
Affiliate Programs
GPS
Laptop Batteries
Hurricane Shutters
Cars

internet.com

IT
Developer
Internet News
Small Business
Personal Technology
International

Search internet.com
Advertise
Corporate Info
Newsletters
Tech Jobs
E-mail Offers

On-demand Webcast: Beyond Basic Data Security. Learn what online sellers can do to better assure reluctant buyers that web transactions are safe.

Drop a Table

The drop table command is used to delete a table and all rows in the table.

To delete an entire table including all of its rows, issue the drop table command followed by the tablename. drop table is different from deleting all of the records in the table. Deleting all of the records in the table leaves the table including column and constraint information. Dropping the table removes the table definition as well as all of its rows.

drop table "tablename"

Example:

drop table myemployees_ts0211;

Drop Table exercises

Drop your employee table.

SQL Interpreter

Finished with this SQL Tutorial? Continue on at the SQLCourse2.com site! This site will provide you with more intermediate & advanced instruction and allow you the ability to practice everything you learn as well!

SQL Course Curriculum
<<previous 1 2 3 4 5 6 7 8 9 next>>

Internet.com Sitemap

IT Channel	All Linux Devices \| AntiOnline \| Apache Today \| ASPNews \| CPU Planet \| DatabaseJournal \| DBASupport.com \| Enterprise IT Planet \| HardwareCentral \| ISP Glossary \| ISP News \| ISP Planet \| Just Linux \| Linux Planet \| ServerCompare \| ServerWatch \| Solaris Guide \| SQLCourse.com \| SQLCourse2.com \| SysOpt \| The List: ASPs \| The List: Broadband \| The List: ISPs \| The List: WebHosts \| The List: WebDesigners \| Thin Planet \| Ultrawideband Planet \| VoIPPlanet \| WebVideoUniverse \| Wi-FIHotSpotList \| Wi-FiPlanet \| WinDrivers \| xSP News
Developer Channel	4GuysFromRolla.com \| 15 Seconds \| ASP101 \| ASP Wire \| FlashKit.com \| HierMenusCentral.com \| JavaScript.com \| JavaScriptSource \| PHPBuilder.com \| ScriptSearch \| StreamingMediaWorld \| The Counter \| The Guestbook \| VB Forums \| VB Wire \| Web Developer's Journal \| Web Developer's Virtual Library \| WebDeveloper.com \| Webreference \| XMLfiles.com
International Channel	asia.internet.com \| germany.internet.com \| japan.internet.com \| korea.internet.com \| turkey.internet.com
InternetNews Channel	Enterprise Linux Today \| Internetnews.com \| Linux Today \| NewsLinx
Personal Technology Channel	BlackBerryToday \| Jumbo \| Megapixel.net \| PocketPCWire \| Palm Boulevard \| PDAStreet \| SharkyExtreme.com \| Smart Phone Today \| WindowsMobileToday
Small Business Channel	ECommerce-Guide \| ECommerce News \| Refer-It \| SmallBusinessComputing \| Webopedia \| WinPlanet

EarthWeb Sitemap

IT Management Channel	bITa Planet \| CIO Update \| Datamation \| DRM Watch \| eCRM Guide \| eSecurityPlanet.com \| GridComputingPlanet \| Inside ID \| Intranet Journal \| IT Career Planet \| ITSMWatch.com \| Project Manager Planet \| Semantic Web
Networking & Communications Channel	EnterpriseNetworkingPlanet \| EnterpriseStorageForum \| Instantmessagingplanet \| OpenNetworksToday \| Optically Networked \| Practically Networked
Web Development Channel	HTML Goodies \| Javascripts.com
Hardware & Systems Channel	EarthWeb Hardware \| SysOpt.com \| Virtual Dr. \| WorkstationPlanet
Software Development Channel	CodeGuru.com \| Developer.com \| jGuru.com \| JARS.com \| Gamelan.com
IT News Channel	EarthWeb.com \| Earthweb News

DevX Channel

APIFinder | Architecture Zone | ASP.NET Zone | C++ Zone | Database Zone | DevX.com | DevXNews | Enterprise Zone | FreeVBCode | JavaBoutique | Java Zone | Mobile Zone | .NET Zone | Open Source Zone | Semantic Web | Visual Basic Zone | Web Dev Zone | XML Zone

MediaBistro Sitemap

Jobs Channel	Ad Agency Jobs \| Book Publishing Jobs \| Corporate Communications Jobs \| Design/Art/Photo Jobs \| Editing Jobs \| Journalism Jobs \| Magazine Publishing Jobs \| Media Sales Jobs \| Newspaper Jobs \| Online/New Media Jobs \| PR/Marketing Jobs \| Radio Jobs \| Teaching/Academia Jobs \| Television Jobs \| Writing Jobs
Education Channel	Corporate Training \| Courses \| Mediabistro On Demand
News Channel	Features \| FishbowlDC \| FishbowlLA \| FishbowlNY \| GalleyCat \| Media News Feed \| TVNewser \| Unbeige
Other Channel	Events \| Forums \| Freelance Marketplace

Graphics Sitemap

Graphics Channel

AdsOfTheWorld.com | CreativeBits.org | Dynamic Graphics | Graphic Design Forum | Graphics.com | Liquid Treat | STEP inside design

Whitepapers and eBooks	Ipswitch Whitepaper: The Changing Role of the Network Administrator \| Quest Software: Adaptive Management to Drive .NET Service Levels \| Electric Cloud: Agile Development--5 Steps to Continuous Integration \| Symantec: Disk-Based Data Protection--Achieve Faster Backups and Restores While Reducing Your Backup Windows \| OpSource PDF: A Step-by-Step Guide to Starting Up Your SaaS Operations \| Intel Article Series: Managing Multi-Core Projects, Part 1: HPC on the Parallelism Frontier \| Atempo Whitepaper: Restore on Storage Area Network \| HP Whitepaper: Benefits to the ITIL Approach to Service Management \| Symantec Whitepaper: Emerging Trends in Fighting Spam \| Verio Whitepaper: Sharks in the AppPool-- Managing Your Web Presence While Protecting Your Hosting Resources \| Swsoft Whitepaper: Top Ten Server Virtualization Technology Considerations \| Innotas Whitepaper: Implementing Project Portfolio Management in Digestible Bites \| Atempo Whitepaper: Integrated Data Protection for the SME \| SWsoft Whitepaper: An Introduction to OS Virtualization and Virtuozzo \| Ipswitch Whitepaper: Evolution from FTP to Secure File Transfer \| Quest Whitepaper: Realizing Continuous Performance Management Best Practices Documentation \| Avaya Whitepaper: SIP--Creating Next-Generation Telecom Applications \| Symantec Whitepaper: Advantages of Integrated Messaging Security
Webcasts	Fluke Networks: Deploy and Troubleshoot Wi-Fi in the Enterprise \| HP: The New Era of Service Management \| Ipswitch: Best Practices in Network Monitoring \| Innotas: 3 Easy Steps to Project Portfolio Management Success \| Tripwire: Preparing for an IT Audit \| DNF Storage: Enterprise iSCSI Storage Options and Applications \| Finisar: Cure Fabric Blindness and Optimize SAN Performance for Application Availability \| Rational Asset Manager: Succeed with Asset-based Development
Downloads and eKits	Sun Java Studio Creator \| IBM Rational Systems Development Solution e-Kit \| IBM SOA Development Survival Guide eKit \| Evaluate IBM Rational Build Forge Online \| IBM Enterprise Architect eKit for SOA \| Evaluate Rational Application Developer Online \| Iron Speed Designer Application Generator \| Symantec IM Detection Utility
Tutorials and Demos	Demo: Unify Your System i Test Efforts with IBM Rational Software \| JavaOne Online Technical Sessions and Labs \| Rational Functional Tester Tutorial: Create Robust, Reusable Automated Functional Tests \| Rational Software Modeler Tutorial: UML 2.0 Modeling \| DB2 9 Tutorial: Shrink Your Database Using Row Compression \| WhatsUp Gold v11 Demo: Discovery, Mapping, Reporting, & Monitoring

Search:

Jupitermedia Corporation has two divisions: Jupiterimages and JupiterOnlineMedia

Jupitermedia Corporate Info

Legal Notices, Licensing, Reprints, & Permissions, Privacy Policy.

Advertise | Newsletters | Tech Jobs | Shopping | E-mail Offers