Home/ Questions/Sql Select All Except One Column
Next
In Process
Seraphina Garcia
  • 16
Asked: 2022-04-22T10:06:15+00:00 In:

Sql Select All Except One Column

  • 16

. Advertisement .

..3..

. Advertisement .

..4..

I am still confused about sql select all except one column and prefer exploring further details. If you have any recommendations, leave it in the anser section.

♦ Suggestions of ITtutoria Team
Ideas for sql select all except one column: 

  1. Enter your table’s name and choose the table you want to use.
  2. Use Alt+F1 to open the menu.
  3. The o/p displays the columns of the table.
  4. Choose the columns you want to view.
  5. Copy and paste these into the query you want to use.
  6. Start the query.
Share

1 Answer

  1. There is a simple method that I found, hope this helps

    /* 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
    • 24

Leave an answer

You must login to add an answer.

Need An Account,