Here's the TSQL for a unique index:
CREATE UNIQUE NONCLUSTERED INDEX IX_UQ_Sample ON Sample (
first ASC, other ASC, something ASC)
I defined Sample as:
CREATE TABLE Sample(
first int NOT NULL, something int NULL, other bit NULL)
I don't know how you'd get SqlAlchemy to generate this when it makes
tables for you.
> actualy this whole mess is because... i need an unique constraint on
> that set of foreign keys, but mssql refused to have unique
> constraints other than the primary key, hence i forced it to be the
> primary key...
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
