Chip: I don't remember the commands but it's in the docs about SQL for 4D.
These might help: http://doc.4d.com/4Dv17/4D/17/CREATE-TABLE.300-3786785.en.html http://doc.4d.com/4Dv17/4D/17/ALTER-TABLE.300-3786784.en.html As much as we don't have PDF's of the docs, there *is* a search function doc.4d.com that queries the version-specific set of docs that have been selected. The two links were from the V17 docs. If I search while having selected the V15 docs, I get a different set of links. It's a very nice feature but I must have missed it when it was announced. -- Douglas von Roeder 949-336-2902 On Fri, Aug 3, 2018 at 8:26 AM Chip Scheide via 4D_Tech < [email protected]> wrote: > I have code (SQL) which creates a unique UUID auto generated primary > key field > However that code is dependent on the table NOT already having such a > field. > > I have a few tables where I have manually created a UUID auto generate > field to be used as a primary key - however - these fields do not have > the attribute 'primary key', and I do not see a means to mark them as > such in the UI. > > What SQL (or other) command can I use to set a field to be a 'Primary > Key'? > Thanks > Chip > --------------- > Gas is for washing parts > Alcohol is for drinkin' > Nitromethane is for racing > ********************************************************************** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
