-ALTER TABLE [SubInd_ch1] ADD
- CONSTRAINT [pk_ch_t_SubInd_ch1] PRIMARY KEY CLUSTERED
- (
- [subsnp_id],
- [submitted_ind_id],
- [batch_id],
- [chr]
- )
+ALTER TABLE [SubInd_ch1] ADD CONSTRAINT [pk_ch_t_SubInd_ch1] PRIMARY KEY CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
GO
-
-ALTER TABLE [SubInd_ch2] ADD
- CONSTRAINT [pk_ch_t_SubInd_ch2] PRIMARY KEY CLUSTERED
- (
- [subsnp_id],
- [submitted_ind_id],
- [batch_id],
- [chr]
- )
+ALTER TABLE [SubInd_ch2] ADD CONSTRAINT [pk_ch_t_SubInd_ch2] PRIMARY KEY CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
GO
-
-ALTER TABLE [SubInd_ch3] ADD
- CONSTRAINT [pk_ch_t_SubInd_ch3] PRIMARY KEY CLUSTERED
- (
- [subsnp_id],
- [submitted_ind_id],
- [batch_id],
- [chr]
- )
+ALTER TABLE [SubInd_ch3] ADD CONSTRAINT [pk_ch_t_SubInd_ch3] PRIMARY KEY CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
GO
-
-ALTER TABLE [SubInd_ch4] ADD
- CONSTRAINT [pk_ch_t_SubInd_ch4] PRIMARY KEY CLUSTERED
- (
- [subsnp_id],
- [submitted_ind_id],
- [batch_id],
- [chr]
- )
+ALTER TABLE [SubInd_ch4] ADD CONSTRAINT [pk_ch_t_SubInd_ch4] PRIMARY KEY CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
GO
-
-ALTER TABLE [SubInd_ch5] ADD
- CONSTRAINT [pk_ch_t_SubInd_ch5] PRIMARY KEY CLUSTERED
- (
- [subsnp_id],
- [submitted_ind_id],
- [batch_id],
- [chr]
- )
+ALTER TABLE [SubInd_ch5] ADD CONSTRAINT [pk_ch_t_SubInd_ch5] PRIMARY KEY CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
GO
-
-ALTER TABLE [SubInd_ch6] ADD
- CONSTRAINT [pk_ch_t_SubInd_ch6] PRIMARY KEY CLUSTERED
- (
- [subsnp_id],
- [submitted_ind_id],
- [batch_id],
- [chr]
- )
+ALTER TABLE [SubInd_ch6] ADD CONSTRAINT [pk_ch_t_SubInd_ch6] PRIMARY KEY CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
GO
-
-ALTER TABLE [SubInd_ch7] ADD
- CONSTRAINT [pk_ch_t_SubInd_ch7] PRIMARY KEY CLUSTERED
- (
- [subsnp_id],
- [submitted_ind_id],
- [batch_id],
- [chr]
- )
+ALTER TABLE [SubInd_ch7] ADD CONSTRAINT [pk_ch_t_SubInd_ch7] PRIMARY KEY CLUSTERED ([chr] ASC,[batch_id] ASC,[subsnp_id] ASC,[submitted_ind_id] ASC)\r
GO
-