Copy Table But Exclude A Column

Hi

Here's a brain-teaser for you all.

I want to create a copy of a table which I do using the code below.

SELECT * INTO My_Temp_Table FROM My_Table WHERE ColumnA = 100

Great, all works well.... but I want to exclude a column when the temp table is being built. I know I could specify all the columns I want leaving out the undesired column (rather than using SELECT *) but there are lots of them and, whilst in development, the table columns are liable to change. So I'd like to copy all coumns that are in force at any given time except one in particular?

I thought it would be something like :-


SELECT * INTO My_Temp_Table FROM My_Table WHERE ColumnA = '100' AND Columnname NOT LIKE 'ColumnB';

But this doesn't work.

Any ideas please?

Many Thanks