Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Editing Objects from Object Browser

SQL Server 2000

You can use Object Browser to alter objects in the database.

To edit an object from Object Browser

  1. In Object Browser, expand a server, and then expand a database.

  2. Right-click the object and click Edit.

    An ALTER statement for the selected object is displayed in the Editor pane. For example, if the selected object is a stored procedure, an ALTER PROCEDURE statement is provided.

  3. Use the ALTER statement to specify the changes.

  4. Execute the ALTER statement.

To delete objects from Object Browser

  • Right-click the object, and then click Delete.

Unlike the Edit command, the Delete command does not display a DROP statement for you to modify and execute. Instead, you are asked to verify that you want to delete the object. If you click OK, the object is deleted.

© 2014 Microsoft. All rights reserved.