The schema name is stored in the header of the VOC file as well as in the UV SQL Catalog, plus it may also be stored in the headers of any files/tables in the account. You could do it manually, but it you would need to know what you were doing!!!
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Jordan Sent: Monday, 11 February 2008 3:46 p.m. To: [email protected] 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 in UniVerse is very painfull, there must be better ways. Ie copying a test account. Regards David Jordan Managing Consultant > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:owner-u2- > [EMAIL PROTECTED] On Behalf Of Ray Wurlod > Sent: Monday, 11 February 2008 7:51 AM > To: [email protected] > Subject: Re: [U2] Change SCHEMA name in UniVerse SQL > > The only legal way is DROP SCHEMA followed by CREATE SCHEMA. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
