how can i create a copy of table with data, indexes and constraints

• vbandlamudi

  Mr or Mrs. 500

  Points: 542

  More actions

  November 5, 2008 at 2:49 am

  #193240

  hi ,

  i have atble named emp which contains an index on empno and a constraint on address columns.

  when i use the following query

  select * into emp_copy from emp.

  here i will get the data and structure of table.

  how can i get the constraints and indexes along with the data and structure???

  please help me

• Renuka__

  Hall of Fame

  Points: 3656

  More actions

  November 5, 2008 at 3:17 am

  #894102

  Hi,

  Using Select into option, the indexes and constraints are ignored. Generate the script of the table by selecting options to include constraints, indexes (right click on tables--> all tasks--> Generate Script).

  Run this script to create another table (emp2).

  Insert into emp2

  select * from emp

  [font="Verdana"]Renuka__[/font]

• alen teplitsky

  SSC-Dedicated

  Points: 30014

  More actions

  November 5, 2008 at 8:08 am

  #894267

  i always use SSIS, just set CopySchema to true and select all the constraints, etc you want to copy over