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

sparky2708

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.

Anu D

Many thanks for your post and we appreciate the requirement specified by you.

But at present SQL prompt does not support synonyms

Please feel free to add your vote for it:

http://redgate.uservoice.com/forums/944 ... ?ref=title

And then the project manager can directly decide what category this requirement comes under?