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

"Expand Wildcards" doesn't work when selecting from synonyms

sparky2708sparky2708 Posts: 2
edited September 26, 2011 4:57AM in SQL Prompt Previous Versions
In my "Data" database I have a table:

CREATE TABLE tblXXXX
(
...
)

In my other database I have:

CREATE SYNONYM tblXXXX for Data..tblXXXX
GO

And then in this other database I try to do:

SELECT *
FROM tblXXXX

And I try to expand the "*" using "Expand Wildcards" from SQL Prompt. It doesn't do anything.

Comments

Sign In or Register to comment.