Renaming a Table

When you rename a table, the reference to it remains the same.

Prerequisites 

Before you can rename a table, be sure to connect to the data server that contains the table.

Note: You cannot rename proxy tables.
  1. In the Databases folder in Enterprise Explorer, under the database connection profile, expand the navigation tree for the appropriate database and schema owner.
    Database Steps
    From an ASE connection profile
    1. Expand the Databases folder.
    2. Expand the tree for a database and then the tree for the appropriate schema owner.
    From a SQL Anywhere or Sybase IQ connection profile
    1. Expand the tree for a database.
    2. Expand the Schemas folder and then the tree for the appropriate schema owner.
  2. Under the Tables folder, find the table you want to rename.
  3. Right-click the table and select Rename.
  4. Enter a new name and click OK.
    Note: Do not use spaces in object names. Spaces could cause the renaming to fail.
Related tasks
Creating a Table
Dropping a Table
Truncating Table Data
Creating an ASE Nonsharable Temporary Table
Creating a SQL Anywhere or a Sybase IQ Temporary Table
Granting and Revoking Table Permissions

Created June 25, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com