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

score 1 · Answer 1 · edited Apr 13 '17 at 12:42

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.

edited Apr 13 '17 at 12:42

Community

1

answered Apr 03 '15 at 11:35

Vérace

26,808
7
61
75

score -4 · Answer 2 · edited Apr 10 '17 at 09:47

-4

create table myNewTable like baseTable;

edited Apr 10 '17 at 09:47

dezso

28,436
12
89
132

answered Apr 10 '17 at 08:50

Madhur Mandhan

1

4

I guarantee that's wrong in SQL Server – Mark Sinkinson Apr 10 '17 at 09:08

copy table with all constraint

2 Answers2