https://communities.sas.com/t5/SAS-Enterprise-Guide/Enterprise-Guide-8-2-load-table-to-SQL-with-primary-key/m-p/680544#M36899 <P>I have a process flow that queries a SQL db and can generate a data set that will be written to another SQL db. I'd like to add a primary key or at the very least, a unique index, such that when my SQL table is loaded, it will reference the pk.&nbsp;</P><P>&nbsp;</P><P>Is this possible? If so, can it be done in Query Builder or do I have to add that syntax in proc sql?</P> Mon, 31 Aug 2020 20:34:16 GMT ssmiley96 2020-08-31T20:34:16Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Enterprise-Guide-8-2-load-table-to-SQL-with-primary-key/m-p/680544#M36899 <P>I have a process flow that queries a SQL db and can generate a data set that will be written to another SQL db. I'd like to add a primary key or at the very least, a unique index, such that when my SQL table is loaded, it will reference the pk.&nbsp;</P><P>&nbsp;</P><P>Is this possible? If so, can it be done in Query Builder or do I have to add that syntax in proc sql?</P> Mon, 31 Aug 2020 20:34:16 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Enterprise-Guide-8-2-load-table-to-SQL-with-primary-key/m-p/680544#M36899 ssmiley96 2020-08-31T20:34:16Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Enterprise-Guide-8-2-load-table-to-SQL-with-primary-key/m-p/680563#M36901 <P>Adding a primary key to an external database will require syntax specific to the SQL language used by that database. You will need to use SQL passthru and the SQL EXECUTE statement, so it will require a coded solution.</P> Mon, 31 Aug 2020 21:52:15 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Enterprise-Guide-8-2-load-table-to-SQL-with-primary-key/m-p/680563#M36901 SASKiwi 2020-08-31T21:52:15Z