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 vote192 views1 answer
Postgresql round double precision
SQL
0 vote187 views1 answer
Codigo crear tablas sql server
SQL
2 votes183 views1 answer
When matched in sql server
SQL
0 vote232 views1 answer
Intellij mysql set timezone
SQL
0 vote179 views1 answer
Components/Fields of Internal Table
SQL
0 vote195 views1 answer
Query for backup a database at another location in file system
SQL
1 vote178 views1 answer
Mysql tables max count
SQL
1 vote186 views1 answer
Use of now() in mysql
SQL
0 vote177 views1 answer
Python sqlalchemy orm to select null values
SQL
0 vote195 views1 answer
How to read the potentail error messages in ssis package
SQL