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

1 vote172 views1 answer
Oracle rolling back
SQL
0 vote183 views1 answer
How to add boolean column in postgresql
SQL
2 votes183 views1 answer
Possgress drop if exists table
SQL
0 vote213 views1 answer
Sqlite version check
SQL
3 votes185 views3 answers
How to add month in update sql
SQL
1 vote201 views1 answer
Mysql drop key
SQL
0 vote196 views1 answer
Extract sql from query object sqlalchemy
SQL
0 vote227 views1 answer
Get from database the most recent data limit by 5
SQL
0 vote203 views1 answer
Query builder doctrien return sql
SQL
0 vote164 views1 answer
How to create an SQL save method in ruby
SQL