You can lock and unlock objects to prevent other developers from making changes while you work with those objects. If you lock an object, then only you can save changes to the object. After you save your changes, you unlock the object so that other developers can make changes to that object.

In some cases, a system administrator may need to force unlock an object. For example, if a user locks an object and then cannot unlock the object because of a holiday or other absence, then the system administrator can force unlock the object. To force unlock an object, the system administrator must have the SUPER user role.

In some cases, you may want to unlock all objects that you have locked. To do this, you can filter on locked objects, select all objects that you have locked, and then unlock these objects.

To unlock an object

  1. In the Classic client, on the Tools menu, click Object Designer.

  2. In Object Designer, select one or more objects that you have locked, and then do one of the following steps:

    • Right-click the object or objects, and then click Unlock.

    • On the File menu, click Unlock.

    • Press CTRL+ALT+U.

To force unlock an object

  1. In the Classic client, on the Tools menu, click Object Designer.

  2. In Object Designer, select one or more objects that you want to force unlock, and then do one of the following steps:

    • Right-click the object or objects, and then click Force Unlock.

    • On the File menu, click Force Unlock.

  3. Confirm that you want to force unlock the object.

    Note
    You must have the SUPER user role to force unlock an object.

To unlock all objects that you have locked

  1. In the Classic client, on the Tools menu, click Object Designer.

  2. In Object Designer, click All.

  3. On the View menu, click Table Filter.

  4. In the Table Filter window, enter Locked By in the Field field, enter your user name in the Filter field, and then click OK.

  5. On the Edit menu, click Select All, and then do one of the following steps:

    • Right-click the object or objects, and then click Unlock.

    • On the File menu, click Unlock.

    • Press CTRL+ALT+U.

See Also