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 vote305 views1 answer
Mysql does collate nopad recognize space
SQL
0 vote336 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
0 vote351 views1 answer
Sql find all different values in column
SQL
0 vote363 views1 answer
Coalesce for comma separated in sql server
SQL
0 vote346 views1 answer
Login failed for login due to trigger execution
SQL
0 vote363 views1 answer
Display all node label neo4j
SQL
0 vote392 views2 answers
Fanyi
SQL
3 votes386 views3 answers
Create table in SQL Server
SQL
0 vote341 views1 answer
Ksql quickstart docker
SQL
0 vote351 views1 answer
Permission denied postgres \copy csv command line
SQL