Roy Lyseng wrote:
Sheeri,
Sheeri K. Cabral wrote:
Personally, I use ALTER TABLE for everything I can . . . I don't use
CREATE INDEX, DROP INDEX, RENAME TABLE, etc. Maybe for SQL standard
compliance?
AFAIK, the SQL standard has no commands for renaming objects.
And indexes are not defined by the standard - they are only part of the
physical schema and do not provide any information to the logical schema.
Cool, this is good to know, Roy, thx. So, I guess this is going to come
down to the following decision:
Is the "ease of use" of the RENAME TABLE (and in future, RENAME SCHEMA)
command worth the current different code paths and complexity?
-jay
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
