Renaming Schema
Renaming Schema
This is a topic for an orphaned message.
Phil,
Bad news. The only legal way - and there is no illegal way - to rename a schema and tables is DROP followed by CREATE.
Recall that the schema name is in the header of the VOC file when the account is created as or coverted into a schema. Tables in the SQL Catalog can not be edited - they are internally marked "read only" and are only updated by DDL statements and VERIFY.SQL.
You can move a schema, then repair the damage with VERIFY.SQL, but you can not rename a schema.
Regards,
Ray
-----Original Message-----
From: Phil Walker [mailto:philw@gnosys.co.nz]
Sent: Wednesday, 23 May 2001 09:00
To: ray.wurlod@informix.com
Subject:
Hi Ray,
What is the easiest way to rename a schema and tables?
Any ideas?
Phil
Bad news. The only legal way - and there is no illegal way - to rename a schema and tables is DROP followed by CREATE.
Recall that the schema name is in the header of the VOC file when the account is created as or coverted into a schema. Tables in the SQL Catalog can not be edited - they are internally marked "read only" and are only updated by DDL statements and VERIFY.SQL.
You can move a schema, then repair the damage with VERIFY.SQL, but you can not rename a schema.
Regards,
Ray
-----Original Message-----
From: Phil Walker [mailto:philw@gnosys.co.nz]
Sent: Wednesday, 23 May 2001 09:00
To: ray.wurlod@informix.com
Subject:
Hi Ray,
What is the easiest way to rename a schema and tables?
Any ideas?
Phil