To delete an object permanently from a database, right-click the object in Data Source Explorer and choose Drop from the menu. The Drop Wizard prompts you to confirm removal of the object and provides a DDL preview of the deletion code.