How can we help you today? How can we help you today?

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

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.
sparky2708
0

Comments

1 comment

Sort by
  • 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?
    Anu D
    0

Add comment

Please sign in to leave a comment.