SQL Server didn't support PK and FK other than for documentation purposes.
These are _not_ upgraded to PK and FK constraints.
The (4.x) "documentation" is found in the syskeys table. There might some
other table as well. You probably have to use some SQL hacking to the info
out so that you can use it to define constraints.
I believe that ODBC uses catalog stored procedure to expose these keys.
These might have been re-written in 6.0, and use documentation for active
constraints. This means that apps that relies on this info will not find the
keys until you port them to constraints (or hack the catalog stored
procedures). Not sure about this, though.
MCSE, MCSD, MCT, SQL Server MVP
Cornerstone Sweden AB
Please do not respond by e-mail unless explicitly asked for.
Anyone knows how can I migrate a SQL Server 6.5 database
to SQL Server 2000 ?
I have a server with SQL Server 6.5 installed...
6. Corrupt fsl