Select all columns except one sql

/* Get the data into a temp table */
SELECT * INTO #TempTable
FROM YourTable
/* Drop the columns that are not needed */
ALTER TABLE #TempTable
DROP COLUMN ColumnToDrop
/* Get results and drop temp table */
SELECT * FROM #TempTable
DROP TABLE #TempTable

Source: stackoverflow.com

Similar codes

0 vote330 views1 answer
Sql query wordpress export post
SQL
5 votes311 views4 answers
Mysql on duplicate key update
SQL
0 vote288 views1 answer
Sql query for select from specific columns in a table
SQL
0 vote337 views1 answer
Write SQL in ruby on rails
SQL
0 vote299 views1 answer
Get number of tables in database sql
SQL
0 vote305 views1 answer
Mysql workbench view
SQL
2 votes299 views1 answer
Sql alchemy or
SQL
0 vote306 views1 answer
Mysql return column names when table is empty
SQL
1 vote334 views1 answer
Primary key with prefix sql
SQL
1 vote311 views1 answer
Hexadec to sql REDSHIFT
SQL