Chuck,
Thanks but...
http://livedoc.4d.com/4D-SQL-Reference-14/Syntax-rules/primary-key-definition.300-1198391.en.html
Says:
[CONSTRAINT sql_name] PRIMARY KEY (sql_name, ... , sql_name)
example:
CREATE TABLE Customer
(SID int32,
Last_Name varchar(30),
First_Name varchar(30),
PRIMARY KEY (SID));
On Mon, 17 Sep 2018 17:10:56 -0400, Chuck Miller via 4D_Tech wrote:
> I think it should be
>
> ALTER TABLE [Anmlprot_File_Link]
> ADD [Journal_Key] [Primary KEY]
>
> This is from the 4D docs
> ALTER TABLE sql_name
> {ADD column_definition [PRIMARY KEY] [TRAILING] |
> DROP sql_name |
> ADD primary_key_definition |
> DROP PRIMARY KEY |
> ADD foreign_key_definition |
> DROP CONSTRAINT sql_name |
> [{ENABLE | DISABLE} REPLICATE] |
> [{ENABLE | DISABLE} AUTO_INCREMENT] |
> [{ENABLE | DISABLE} AUTO_GENERATE] |
> SET SCHEMA sql_name}
>
> Chuck
>
------------------------------------------------------------------------------------------------
> Chuck Miller Voice: (617) 739-0306
> Informed Solutions, Inc. Fax: (617) 232-1064
> mailto:cjmiller<AT SIGN>informed-solutions.com
> Brookline, MA 02446 USA Registered 4D Developer
> Providers of 4D and Sybase connectivity
> http://www.informed-solutions.com
>
------------------------------------------------------------------------------------------------
> This message and any attached documents contain information which may
> be confidential, subject to privilege or exempt from disclosure under
> applicable law. These materials are intended only for the use of the
> intended recipient. If you are not the intended recipient of this
> transmission, you are hereby notified that any distribution,
> disclosure, printing, copying, storage, modification or the taking of
> any action in reliance upon this transmission is strictly
> prohibited. Delivery of this message to any person other than the
> intended recipient shall not compromise or waive such
> confidentiality, privilege or exemption from disclosure as to this
> communication.
>
>> On Sep 17, 2018, at 3:48 PM, Chip Scheide via 4D_Tech
>> <4d_tech@lists.4d.com> wrote:
>>
>> $SQl_Command:="ALTER TABLE [Anmlprot_File_Link] ADD PRIMARY KEY
>> (Journal_Key)"
>
> **********************************************************************
> 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
**********************************************************************
