I have a table with identity column say:
create table with_id ( id int identity(1,1), val varchar(30) );
It's well known, that this
select * into copy_from_with_id_1 from with_id;
results in copy_from_with_id_1 with identity on id too.
The following stack overflow question mentions listing all columns explicitly.
select id, val into copy_from_with_id_2 from with_id;
Oops, even in this case id is an identity column.
What I want is a table like
create table without_id ( id int, val varchar(30) );