Thanks, I do not really use the online docs.... but it is nice to know Chip
On Fri, 3 Aug 2018 08:45:31 -0700, Douglas von Roeder via 4D_Tech wrote: > 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 < > 4d_tech@lists.4d.com> 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:4d_tech-unsubscr...@lists.4d.com >> ********************************************************************** > ********************************************************************** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** --------------- 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:4d_tech-unsubscr...@lists.4d.com **********************************************************************