RE: [U2] Change SCHEMA name in UniVerse SQL

2008-02-12 Thread Ray Wurlod
it. - Original Message - From: phil walker [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Subject: RE: [U2] Change SCHEMA name in UniVerse SQL Date: Wed, 13 Feb 2008 07:52:52 +1300 Ray, If a file has a trigger then there is information in the header about the trigger

RE: [U2] Change SCHEMA name in UniVerse SQL

2008-02-12 Thread phil walker
p.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] Change SCHEMA name in UniVerse SQL If the schema was created after the account (that is, the CREATE SCHEMA was executed in an existing account or the HOME option pointed to an existing account) then the UniVerse account (non-schema

RE: [U2] Change SCHEMA name in UniVerse SQL

2008-02-11 Thread Ray Wurlod
If the schema was created after the account (that is, the CREATE SCHEMA was executed in an existing account or the HOME option pointed to an existing account) then the UniVerse account (non-schema) will continue to exist after the DROP SCHEMA command has been executed. Any UniVerse files (not

Re: [U2] Change SCHEMA name in UniVerse SQL

2008-02-10 Thread Ray Wurlod
The only legal way is DROP SCHEMA followed by CREATE SCHEMA. - Original Message - From: David Jordan [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Subject: [U2] Change SCHEMA name in UniVerse SQL Date: Sun, 3 Feb 2008 10:45:47 +1100 Does anyone know how to change the SQL

RE: [U2] Change SCHEMA name in UniVerse SQL

2008-02-10 Thread David Jordan
PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: Monday, 11 February 2008 7:51 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Change SCHEMA name in UniVerse SQL The only legal way is DROP SCHEMA followed by CREATE SCHEMA. --- u2-users mailing list u2-users

RE: [U2] Change SCHEMA name in UniVerse SQL

2008-02-10 Thread LeRoy Dreyfuss
- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan Sent: Monday, February 11, 2008 12:01 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Change SCHEMA name in UniVerse SQL Hi Ray To drop schema means that you have to drop all the tables as well? The moving

RE: [U2] Change SCHEMA name in UniVerse SQL

2008-02-10 Thread phil walker
] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan Sent: Monday, 11 February 2008 3:46 p.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] Change SCHEMA name in UniVerse SQL Hi Ray To drop schema means that you have to drop all the tables as well? The moving of scemas, copying schemas, etc