How call Primary keys with arbitrary name?

Topics: User Forum
Feb 12, 2007 at 9:14 PM
How call Primary keys with arbitrary name?
In case of renaming the column "oid" (default on import from shp file) some triggers (ej. STGeometryTableTriggermytablethegeom) refer to a "oid" column. Or I'm wrong?
Sorry my ignorance.
Regards
/Leandro
Coordinator
Feb 13, 2007 at 12:36 PM
If you create the table from scratch, you can use any name you like and then add geometry columns.
Also you can rename the primary key column and use "msscmd.exe -deploy" (a slow but safe method).

Using sp_executesql in the trigger or a DDL trigger would be better. For the next release...

Best regards,
Ricardo Stuven.