Select * Except?

[gbaughma]

So, I have some tables that I regularly have to display *almost* all of the fields on.

Besides saying:

SELECT Field1, Field2, Field3... Field50 FROM...


... is there a way to:

SELECT * Except Field1 FROM

Something along those lines?



Just my 2¢

"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."

--Greg

http://parallel.tzo.com

 

[markros]

No. Listing all fields is the only way. Alternatively you can build dynamic select statement using INFORMATION_SCHEMA.COLUMNS view.

PluralSight Learning Library

 

[SQLSister]

Nope but in SQL Server you can just drag all the column names over from the browser in one step and then just delete the few you don't want from the list. Much faster and more accurate than typing them.

"NOTHING is more important in a database than integrity." ESquared

 

[simian336]

or right click on the table and choose
"Script Table as" then
"Select to" then
"New Query Editor Window" or "Clipboard"

Then edit the list.

Simi

 

[gbaughma]

Yeah... I was afraid that was going to be the answer.

I've started writing some rather complex (for me, anyway) SQL scripts.

Actually, I'm quite proud of myself.... I figured out how to do a stored procedure that I can pass parameters to that returns a pivot table.

I know... small-time stuff for some of the SQL Gurus here, but still, big stuff for me.



Just my 2¢

"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."

--Greg

http://parallel.tzo.com

 

[gmmastros]

Just out of curiosity... Are you using temp tables and joining on varchar columns?

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom