Change Primary Key?

3 posts by 3 authors in: Forums > CMS Builder
Last Post: March 26, 2018   (RSS)

By (Deleted User) - March 25, 2018

Hello, 

I need to run a more complex custom query, and what I need is the ability to have a composite primary key. The primary key needs to be a combination of 3 different columns. Is this possible? If so, how can I achieve this.

Thanks

By Dave - March 26, 2018

Hi testplan, 

Yea, there's no support for composite primary keys.  So options would be to try some things and see if CMSB still works with it (it's always going to expect a num column), or perhaps have an additional table that isn't managed by CMSB. 

Hope that helps!

Dave Edis - Senior Developer
interactivetools.com