schema/human_9606_schema/human_gty1_constraint.sql

   1 ALTER TABLE [SubInd_ch1] ADD
   2         CONSTRAINT [pk_ch_t_SubInd_ch1] PRIMARY KEY  CLUSTERED
   3         (
   4                 [subsnp_id],
   5                 [submitted_ind_id],
   6                 [batch_id],
   7                 [chr]
   8         )
   9 GO
  10
  11
  12 ALTER TABLE [SubInd_ch2] ADD
  13         CONSTRAINT [pk_ch_t_SubInd_ch2] PRIMARY KEY  CLUSTERED
  14         (
  15                 [subsnp_id],
  16                 [submitted_ind_id],
  17                 [batch_id],
  18                 [chr]
  19         )
  20 GO
  21
  22
  23 ALTER TABLE [SubInd_ch3] ADD
  24         CONSTRAINT [pk_ch_t_SubInd_ch3] PRIMARY KEY  CLUSTERED
  25         (
  26                 [subsnp_id],
  27                 [submitted_ind_id],
  28                 [batch_id],
  29                 [chr]
  30         )
  31 GO
  32
  33
  34 ALTER TABLE [SubInd_ch4] ADD
  35         CONSTRAINT [pk_ch_t_SubInd_ch4] PRIMARY KEY  CLUSTERED
  36         (
  37                 [subsnp_id],
  38                 [submitted_ind_id],
  39                 [batch_id],
  40                 [chr]
  41         )
  42 GO
  43
  44
  45 ALTER TABLE [SubInd_ch5] ADD
  46         CONSTRAINT [pk_ch_t_SubInd_ch5] PRIMARY KEY  CLUSTERED
  47         (
  48                 [subsnp_id],
  49                 [submitted_ind_id],
  50                 [batch_id],
  51                 [chr]
  52         )
  53 GO
  54
  55
  56 ALTER TABLE [SubInd_ch6] ADD
  57         CONSTRAINT [pk_ch_t_SubInd_ch6] PRIMARY KEY  CLUSTERED
  58         (
  59                 [subsnp_id],
  60                 [submitted_ind_id],
  61                 [batch_id],
  62                 [chr]
  63         )
  64 GO
  65
  66
  67 ALTER TABLE [SubInd_ch7] ADD
  68         CONSTRAINT [pk_ch_t_SubInd_ch7] PRIMARY KEY  CLUSTERED
  69         (
  70                 [subsnp_id],
  71                 [submitted_ind_id],
  72                 [batch_id],
  73                 [chr]
  74         )
  75 GO
  76
  77
  78