Home

Deleting a Table

 

Introduction

To visually delete a table, in the Object Explorer, expand its database and the Tables node. Right-click the table and click Delete. In the dialog box, click OK.

To delete a table using SQL, use the following formula:

DROP TABLE TableName

The DROP TABLE expression is required and it is followed by the name of the undesired table. Here is an example:

DROP TABLE Students;
GO
 
 

Home Copyright © 2008-2011 FunctionX.com