I have a DB that creates a table the defines the primary key thus

EXEC sp_primarykey 'blah', blahuid

then does the foreigns

EXEC sp_foreignkey 'blah2', '.field', uid

I can't find the Procedures to transfer them. going from an ASE to a ASA

where are the procedures?

Thanks for help
A

sp_primarykey, sp_foreignkey . . . are documentation features only in ASE.
Nothing actually happens inside Sybase to enforce them. So, the question
is, why does your product need them in ASA?

There are cases where one wants these: third party programs might read
them. If you want to generate code for this, the DBPowerSuite program
psCopyKeys generates a SQL script.

www.dbpowersuite.com




"Baldy" <John (AT) smith (DOT) com> wrote

Unfortunatly dbpowersuite is unix only app. I've gone to the dark side so
need a windows thing.

Are you sure they are documentation only? As the tables are generated with
no PK's or FK's and the stored procs seem to be trying to produce them else
there are no links at all.

Thanks for your time
A


"Brian Ceccarelli" <spam (AT) accipiter (DOT) com> wrote