How to: Delete Database Objects
To delete a database object from a database project, you delete the file that contains the object definition from Solution Explorer. After you delete one or more objects from a database project, you must build and deploy the changes to your database server.
To delete the file that contains an object definition from a database project
In Solution Explorer, click the file that represents the object that you want to delete.
On the Edit menu, click Delete. You can also click the object and press the DELETE key.
A confirmation dialog box appears.
In the confirmation dialog box, click OK.
The object is deleted from the database project in both Solution Explorer and Schema View. If the database project is under version control, when you delete the object, the project file will be checked out. If the object you deleted had child objects, such as indexes or keys on a table, the child objects will appear in the Orphaned Objects folder in Schema View. Errors will appear in the Error List indicating that the parent object cannot be found.
For the change to be reflected on the database server, you must build and deploy your changes. For more information, see How to: Prepare Database Build Scripts.