Keys for tables?

[Lukus]

there are no (or very few) keys in the SQL tables... Just a general concern i've been having... i realise that SC has keys set up in the application level, but would it help to add them at DB level?

has anyone actually gone into SQL and set up Primary keys?
i'd expect this to help with SQL operations...

thoughts?

Cheers,
Lukus

[tommy]

You definately need the keys on db level. When pushed to external RDBMS the keys in P4 are ignored but should have been created when you moved the files. (There migth be a differnce between SC 6.x and SM 7.x though and you didn't mention what version you run).

[Lukus]

ahh... i'll have to do some checking.

running 6x.

thanks Tommy.