Rename, unlock, or copy a database-related artifact.
Syntax
Use alter object to edit artifacts in the following ways:
Keyword | Description | ||
---|---|---|---|
rename to | Rename the artifact. Not applicable for partition files, worksheets, or outlines. | ||
unlock | Unlock an artifact that is locked by another user or process. Not applicable for alias tables and worksheets. Unlocking an artifact of type lro is applicable for stored linked-reporting objects only; that is, files with the .LRO extension.
| ||
copy to | Make a copy of a server artifact. Not applicable for partition files, worksheets, or outlines. If an artifact of the new name already exists, it is replaced. | ||
force copy to | Make a copy of a server artifact. Not applicable for partition files, worksheets, or outlines. If an artifact of the new name already exists, it is replaced. If an administrator issues the statement with the force keyword, locked artifacts are unlocked, copied, and re-locked. |
Notes
Specified artifacts must be persisted in the database directory.
To copy artifacts that are not persisted in the database directory, use the EXPORT ESSCMD command.
Attempting to rename or copy an artifact of type “partition_file” returns an error.
Example
alter object sample.basic.genref of type rules_file rename to 'level';
Renames a rules file in the Sample Basic directory, named genref.rul, to level.rul.
alter object sample.basic.Calcdat of type text rename to 'c_data';
Renames a text file in the Sample Basic directory, named calcdat.txt, to c_data.txt.
alter object samppart.company.company of type partition_file unlock;
Unlocks the partition definition file for the Samppart Company database.