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

11 votes328 views2 answers
Having keyword sql
SQL
0 vote363 views2 answers
Search stored procedures by name
SQL
5 votes329 views3 answers
Truncate function in sql oracle
SQL
3 votes358 views2 answers
Oracle grants
SQL
0 vote359 views4 answers
What is unique key in sql
SQL
0 vote381 views1 answer
Default column value in sql same as another column laravel
SQL
0 vote337 views1 answer
Sql select rows between 1000 and 2000
SQL
13 votes333 views2 answers
Display users in mysql
SQL
0 vote379 views2 answers
Get value from a table an insert it with other values in another table sql
SQL
0 vote381 views1 answer
Selecting Multiple Columns in SQL
SQL