Hello everybody,

I need to save a view with a table with wildcard, like “SELECT * FROM country”.

However, the MS SQL-Management Studio automatically expands the the wildcard with the fields of the  table “country”, to “SELECT country.id, country.description, country.president FROM country”.

Since the respective table is supposed to be user-defined, the view that I deploy must contain a wildcard rather than named fields.

So: how do I deactivate the automatic expanson of this wildcard?

Hoping for help

Joachim

​Hello everybody, I need to save a view with a table with wildcard, like “SELECT * FROM country”. However, the MS SQL-Management Studio automatically expands the the wildcard with the fields of the  table “country”, to “SELECT country.id, country.description, country.president FROM country”. Since the respective table is supposed to be user-defined, the view that I deploy must contain a wildcard rather than named fields. So: how do I deactivate the automatic expanson of this wildcard? Hoping for helpJoachim  Read More

​