Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

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

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

Caution noteCaution

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.

To delete a table from the database

  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.

    NoteNote

    Deleting a table automatically removes any relationships to it.

Community Additions

ADD
Show:
© 2015 Microsoft