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

Provides intelligent code completion for SQL Server editors.

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

Postby dbentley1267 » Tue Jan 14, 2014 11:14 am

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
Posts: 1
Joined: Mon Jan 13, 2014 10:10 pm

Postby Aaron Law » Tue Jan 14, 2014 2:18 pm

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?
Aaron Law
Posts: 597
Joined: Fri Jun 28, 2013 9:56 am
Location: Red Gate Software

Return to SQL Prompt

Who is online

Users browsing this forum: No registered users and 0 guests