Moving, Copying, Deleting, or Renaming a Resource
You can move a resource by cutting a resource and pasting it into another location, or by renaming it, subject to the following rules:
• You cannot move an unpublished resource into
Data Services, which only stores resources that have been published. See
About Publishing Resources.
• You cannot move a published resource out of a Data Services container. You must delete it, and then, if you want, republish it.
• The only way to move the children of a data source is to move the entire data source.
• You can move a container (except a system-created container). When you do, all of the resources it contains are moved.
• You can move a leaf, such as a view or a procedure.
• As with any cut and paste sequence, if you cut a resource and do not paste it in its new location before you cut or copy another resource, the original resource is lost.
You can rename any resource in the resource tree. All references to the original filename in the SQL within resources in Studio are also changed to the new name. Resources with dependencies that are currently opened are closed to update and accommodate the changed dependency name.
Note: If the configuration option “Require Grant Privilege” is tuned to be True, then a user performing the copy-paste operation should have GRANT privilege on the source, in order to copy all sensitive information from the source. By default this is set to False. To change this setting, follow these steps:
1. Go to Administration > Configuration
2. Locate the Require Grant Privilege option. It can be found in Server > Configuration > Metadata
3. Change the value to True.
4. Click Ok.
To move a resource
1. Right-click the name of the resource and select Cut, or select the resource name and click the Cut toolbar button.
2. Right-click the name of the container in which to place the resource, and select Paste into; or select the container name and select the Paste into button on the toolbar.
To copy a resource
1. Right-click the name of the resource and select Copy; or select the resource name and click the Copy toolbar button.
2. Right-click the name of the destination container and select Paste into; or select the container name and select the Paste into button on the toolbar.
To delete a resource
1. Right-click the resource, and select Delete; or select the resource and click the Delete button.
To select multiple resources for deleting, hold down Ctrl while selecting the resources one by one, or hold down Shift while selecting a set of adjacent resources.
2. In the Confirmation window, click Yes.
To rename a resource
1. Right-click the resource, and select Rename; or select the resource and then the Edit > Rename option.
2. Place the cursor anywhere on the resource name, type a new name, and press Enter.