All Products
Search
Document Center

RENAME

Last Updated: Jun 18, 2021

Description

The RENAME statement renames an object.

Syntax

RENAME obj_name TO new_obj_name;

Parameter description

Parameter

Description

obj_name

The original name of the object.

new_obj_name

The new name of the object.

Examples

  1. Create tables t1 and t2.

create table t1(c1 int);
  1. Rename table t1 to t11.

rename t1 to t11;

Considerations

You can rename tables, views, private synonyms, and sequences.