Query Designer Automatically Expanding Select *

Ok this is a BIG annoyance. When I type Select * from table in one of the SQL
Query Tabs and then open the Query Designer it auto expands my query to show
all the fields. Example say my table has 30 fields when view it will expand
my query to read
select
field1,
field2,
field3,
etc....
from
table
is there any way to turn this feature off? I already think the query
designer has been severely hindered in this version of SQL Server because you
cant run the query in the designer.
Nope, I personally do agree with the approach, since select * is error prone
for a couple of reasons inside an application.
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2005 All rights reserved.
"Jim" <Jim@.discussions.microsoft.com> wrote in message
news:9699BF30-86BC-473C-A9CA-B680EB5BF727@.microsoft.com...
> Ok this is a BIG annoyance. When I type Select * from table in one of the
> SQL
> Query Tabs and then open the Query Designer it auto expands my query to
> show
> all the fields. Example say my table has 30 fields when view it will
> expand
> my query to read
> select
> field1,
> field2,
> field3,
> etc....
> from
> table
> is there any way to turn this feature off? I already think the query
> designer has been severely hindered in this version of SQL Server because
> you
> cant run the query in the designer.
>
|||You are correct it can be error prone however my complaint is more about
something automatically changing something on me. I should be allowed to
turn the feature on or off.
"Gert E.R. Drapers" wrote:

> Nope, I personally do agree with the approach, since select * is error prone
> for a couple of reasons inside an application.
> GertD@.SQLDev.Net
> Please reply only to the newsgroups.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> You assume all risk for your use.
> Copyright ? SQLDev.Net 1991-2005 All rights reserved.
> "Jim" <Jim@.discussions.microsoft.com> wrote in message
> news:9699BF30-86BC-473C-A9CA-B680EB5BF727@.microsoft.com...
>
>