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

Provides intelligent code completion for SQL Server editors.

Moderators: Anu Deshpande, Aaron Law, David Priddle

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

Postby dbentley1267 » Tue Jan 14, 2014 12:14 pm

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

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

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


Return to SQL Prompt 6

Who is online

Users browsing this forum: No registered users and 0 guests