ALTER SOURCE
Use the ALTER SOURCE command along with RENAME TO to modify the existing source name.
Syntax
ALTER SOURCE current_source_name
RENAME TO new_source_name;
Parameters
| Parameter or clause | Description |
|---|---|
| current_source_name | The current name of the source you want to modify. |
| RENAME TO | Indicates the intention to rename the specified source. |
| new_source_name | The new name you want to assign to the source object. |
Example
ALTER SOURCE src
RENAME TO src1;