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

Hi Julio,

Julio Carneiro wrote:
> But I cannot find any way to retrieve that AUTO_INCREMENT property. I  
> know I can set it via SQL DDL and the Structure Editor.

Sorry, my bad, I think the table you want _USER_CONS_COLUMNS.  This
table has all of the column constraints.

Note: I don't know what the query is to get the information you want
(otherwise I would post it)...just trying to point you in the right
direction.

Kind regards,

Josh Fletcher

--
Josh Fletcher
Technical Services Team Member
4D, Inc.
**********************************************************************
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@...
**********************************************************************