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

Re: 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

Nope... _USER_CONS_COLUMNS does not show auto_increment. I guess that  
property is not exposed in any way...

On Jul 2, 2009, at 9:30 PM, Josh Fletcher (4D, Inc.) wrote:

> 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

**********************************************************************
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