What are the challenges you face when working across database platforms? Take the survey
Options

Select * (replace with columns) is not picking up the PK

dbentley1267dbentley1267 Posts: 2
edited January 14, 2014 9:18AM in SQL Prompt
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

Comments

  • Options
    Aaron LAaron L Posts: 596 New member
    Hi,
    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?
Sign In or Register to comment.