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.

Roy

_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help   : https://help.launchpad.net/ListHelp

Reply via email to