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

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) will

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 t

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

RE: [U2] Change SCHEMA name in UniVerse SQL

2008-02-10 Thread LeRoy Dreyfuss
ssage- 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 movi

RE: [U2] Change SCHEMA name in UniVerse SQL

2008-02-10 Thread David Jordan
[EMAIL 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. ---

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

[U2] Change SCHEMA name in UniVerse SQL

2008-02-02 Thread David Jordan
Does anyone know how to change the SQL schema name for an account in UniVerse. Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/