Learn how to use the SQL Server to delete a table from a database.
Important: Before executing any queries on an Advance Steel database, make sure you create backup copies of the databases that will be modified, by adding them in a backup folder in a desired location on the disk.
To delete a table from a database:
- In the Object Explorer, right-click on the database containing the table you want to delete and select New Query from the contextual menu.
- This will open a new tab window on the right side.
- Type the following query line in the new window:
drop table [dbo].[name of table]
- After executing the query, refresh the table list.
- The deleted table will no longer be available in the list.