Jaa


Delete Objects (SQL Server Compact Edition)

The Delete Object dialog box in and SQL Server Management Studio Express lets you delete database objects such as a table, index, trigger, view, key, constraint, default, rule, user-defined data type, or stored procedure.

Options

Objects to be deleted

Displays the list of database objects to be deleted. It displays the object name, object type, status, and message, if any, for the list of objects to be deleted.

Refresh

The Refresh button at the top helps you update the list of objects to be deleted.

Note

The Schedule and Script button will always be deactivated because these features are not supported by Microsoft SQL Server 2005 Compact Edition.

Remove

The Remove button at the right corner of the dialog box lets you remove the objects from the list that you do not want to delete.