Viewing 3 posts - 1 through 3 (of 3 total)
Is this what you are looking for...
select * into table2 from table1
will create table2 with same structure and data as table1.
check for indexes and default values in table2
June 28, 2006 at 5:59 am
#646336
I mean datetime
June 28, 2006 at 5:36 am
#646333
Thats the datatime datatype
June 28, 2006 at 5:35 am
#646331