Frank Rust <[EMAIL PROTECTED]> wrote on 12/09/2005 01:59:35 AM: > Is there a possibility to select all columns from a table except one or > two columns? For example I have a table with 30 columns and want all > columns but one column *not*. Do I have to write a very long select > statement with 29 column names that i want to get? > > -- > ________________________________________________________________________ > Frank Rust, Technische Universität, Institut für Theoretische Informatik > Tel.: +49 531 391 9525 Postfach 3329, D-38023 Braunschweig > Fax.: +49 531 391 9529 Mühlenpfordtstr. 22-23, D-38106 Braunschweig > >
Nope, it's not part of the SQL standard to write a query that way. In fact, I cannot think of a single database (commercial or free) with that capability in their query syntax (and I have used a lot of them). Sorry! Shawn Green Database Administrator Unimin Corporation - Spruce Pine
