« Return to Thread: Is there a way to get a table's primary key in V11

Is there a way to get a table's primary key in V11

by Julio Carneiro :: Rate this Message:

Reply to Author | View in Thread

In pre-V11 I used a convention to flag a field as Primary Key: any  
field with indexed+unique+nonenterable+nonmodifiable+displayonly  
attributes is a PK for me.

In V11 I want to use a different combination: autoincrement+unique ==>  
PK.

I checked the documentation and could not find a way to get the 'auto  
increment' field attribute.
Neither Get Field Properties nor Get Field Entry Properties returns  
that attribute.

Does anyone know a way to get that info? Is it available in the System  
Tables, accessible via SQL?

TIA
julio

**********************************************************************
Live Data Mapping Services with 4D v11 SQL
See it for yourself - http://www.4d.com/solutions/ndwater.html

4D Internet Users Group (4D iNUG)
FAQ:  http://www.4D.com/support/faqnug.html
Archive:  http://lists.4D.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4D_Tech-Unsubscribe@...
**********************************************************************

 « Return to Thread: Is there a way to get a table's primary key in V11