With select * into the test from table1 where 1=2 copy table1 table structure, the table is copied out, but on the surface of the table fields, field required set didn't copy the past, do not know what reason be?

CodePudding user response:

This is an additional table query, some fields that attributes such as not being copied

CodePudding user response:

reference 1/f, not the miracle of mace response:

this is an additional table query, some fields shows that property will not be copied, such as

How to deal with that, please?

CodePudding user response:

Can only be added manually or, in the code

CodePudding user response:

Can set the rs=and SQL content posted? I tested, it is not correct!