Red Gate forums :: View topic - Select * (replace with columns) is not picking up the PK
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 6
SQL Prompt 6 forum

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

Search in SQL Prompt 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
dbentley1267



Joined: 13 Jan 2014
Posts: 1

PostPosted: Tue Jan 14, 2014 12:14 pm    Post subject: Select * (replace with columns) is not picking up the PK Reply with quote

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
Back to top
View user's profile Send private message
Aaron Law



Joined: 28 Jun 2013
Posts: 249
Location: Red Gate Software

PostPosted: Tue Jan 14, 2014 3:18 pm    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group