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 vote325 views1 answer
Connect postgresql using a connection string
SQL
0 vote326 views1 answer
How to display value of variable in mysql
SQL
0 vote341 views1 answer
Drush run sql select
SQL
7 votes380 views1 answer
Buy forge mods server hosting
SQL
0 vote323 views1 answer
Casterar postgres
SQL
0 vote533 views1 answer
Multiple row join
SQL
0 vote338 views1 answer
Mysql date time string format for marshmellow field schema
SQL
1 vote348 views1 answer
Age postgres
SQL
13 votes364 views4 answers
What is sql
SQL
0 vote323 views1 answer
Truncate a table then insert data
SQL