copy table with all constraint

Question

how I would copy a table with all constraints?

I run select * into myNewTable from baseTable where 1=0

This copy a table but no with constraints

Answer 1

You have to use the GUI management tool to create a script and then run that - you cannot do it directly - take a look here (or here) for relatively clear explanations.

Answer 2

create table myNewTable like baseTable;