Search
Submit a request
Sign in
How can we help you today?
Categories
Submit a request
Submit a request
Sign in
Support
Community
SQL Prompt
Select * (replace with columns) is not picking up the PK
New post
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
January 14, 2014 06:14
-
0
+
Comments
1 comment
Sort by
Date
Votes
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 L
January 14, 2014 09:18
-
0
+
Add comment
Please
sign in
to leave a comment.
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