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

I may be blind. I did find reference to System Tables on page 81 of
4D_v11_SQL_Reference_r4.pdf.

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.

What I want is to get that property, not set it.

I am writing generic code where all I know is a table name and I need
to find that table's Primary Key.

julio

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

> Hi Julio,
>
> Julio Carneiro wrote:
>> I do not see any reference to SQL System Tables in the SQL
>> reference manual.
>
> It's on page 81 of "4D_v11_SQL_Reference_r3.pdf".
>
> The SQL keyword is "AUTO_INCREMENT" IIRC.
>
> -Josh
>
>

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