Re: [Sqlalchemy-users] UNIQUE constraint vs. UNIQUE index

2006-07-13 Thread Rick Morrison
Just tested with MS-SQL and Sqlite, both accept the syntax fine.FWIW, MS-SQL does the behind-the-scenes unique index create.On 7/13/06, William K. Volkman <[EMAIL PROTECTED]> wrote: Hi Michael,On Thu, 2006-07-13 at 14:54, Michael Bayer wrote:> hey list ->> im working on explicit CONSTRAINT objects

Re: [Sqlalchemy-users] UNIQUE constraint vs. UNIQUE index

2006-07-13 Thread William K. Volkman
Hi Michael, On Thu, 2006-07-13 at 14:54, Michael Bayer wrote: > hey list - > > im working on explicit CONSTRAINT objects, primarily a FOREIGN KEY > constraint which cleanly allows composite foreign keys that work in a > CREATE statement. but while im adding "ForeignKeyConstraint", im > also

[Sqlalchemy-users] UNIQUE constraint vs. UNIQUE index

2006-07-13 Thread Michael Bayer
hey list - im working on explicit CONSTRAINT objects, primarily a FOREIGN KEY constraint which cleanly allows composite foreign keys that work in a CREATE statement. but while im adding "ForeignKeyConstraint", im also adding a distinct "PrimaryKeyConstraint" as well as "UniqueConstraint".