table data copying in sql

Question

data present in one table is copied into other table in sql along with constraints like primary key,check,default,foreign key also present in copied table ?