Select * (replace with columns) is not picking up the PK
dbentley1267
Posts: 2
I seem to have an issue using the replace * function.
I have some tables where the PK was defined later and is the last column on the table.
when using the Replace * it does not pick up the PK
I have some tables where the PK was defined later and is the last column on the table.
when using the Replace * it does not pick up the PK
Comments
It may be that the version of the database that prompt has cached is out of date (and is missing this column that you've added). You could try using "Refresh Suggestions" from the SQL Prompt menu to force an update to see if that helps?