Ray, If a file has a trigger then there is information in the header about the trigger. Is there anything in this information which contains the schema?
Phil -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ray Wurlod Sent: Tuesday, 12 February 2008 9:00 p.m. To: [email protected] 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 continue to exist after the DROP SCHEMA command has been executed. Any UniVerse files (not tables) will continue to exist. However, any UniVerse tables will be dropped. There is NOTHING in the header of any file except VOC to indicate that it is in a schema. UniVerse tables, their columns and associations, and any views based upon them, are recorded in tables in the SQL CATALOG. ------- 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/
