There's nothing like that but you can use following T-SQL script to generate SELECT statements for tables and then remove column(s) you doun't need
http://www.umachandar.com/technical/SQL70Scripts/Main12.htm>Hi,
>
>I need to select all columns on a table except one. Right now I have to type a lot of columns in the query to accomplish this. Would be nice something like "Select * except cRegion FROM Countries", is there a way to do this in SQL Server?
>
>Thanks.
--sb--