SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
This topic has not yet been rated - Rate this topic

How to: Delete Tables from a Database (Visual Database Tools)

SQL Server 2005

You can delete a table from your database using Object Explorer.

ms190616.Caution(en-US,SQL.90).gifCaution:
Think carefully before you delete a table. If existing queries, views, user-defined functions, stored procedures, or programs refer to that table, the deletion will make these objects invalid.

  1. In Object Explorer, select the table you want to delete.

  2. Right-click the table and choose Delete from the shortcut menu.

  3. A message box prompts you to confirm the deletion. Click Yes.

    ms190616.note(en-US,SQL.90).gifNote:
    Deleting a table automatically removes any relationships to it.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.