Ahhhh. Another point. When I create PK on 2 columns or unique on 2 columns. VS always creates a key on these columns on DataTable level. No unique is set for columns.
It seems to me, that unique and PK is from MS SQL's provider and VS's view the same and they're handling it in a "special" way. IMHO I consider this as not a bug. Firebird's provider has better granularity on constrains that mssql's (they're making some hacks to make VS methods work correctly with VS keys design). If there's somebody who can prove contrary, I can check our code for problems. -- Jiri {x2} Cincura http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com ------------------------------------------------------------------------- This SF.net email is sponsored by DB2 Express Download DB2 Express C - the FREE version of DB2 express and take control of your XML. No limits. Just data. Click to get it now. http://sourceforge.net/powerbar/db2/ _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider