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

4 votes142 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
0 vote129 views1 answer
Mysql procedure between two tables
SQL
0 vote134 views1 answer
Postgresql custom order by
SQL
0 vote137 views1 answer
Shows all databases created by user in ms sql
SQL
0 vote126 views1 answer
Psql attribute cannot login
SQL
2 votes124 views1 answer
Oracle generated column
SQL
4 votes82 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL
0 vote123 views1 answer
Sql quary intervewi question
SQL
0 vote129 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
2 votes174 views1 answer
Oracle Column Names of a table
SQL