改变表已添加约束、外键

ALTER TABLE [dbo].[employee] WITH NOCHECK ADD
 CONSTRAINT [DF__employee__job_id__1B0907CE] DEFAULT (1) FOR [job_id],
 CONSTRAINT [DF__employee__job_lv__1CF15040] DEFAULT (10) FOR [job_lvl],
 CONSTRAINT [DF__employee__pub_id__1DE57479] DEFAULT ('9952') FOR [pub_id],
 CONSTRAINT [DF__employee__hire_d__1FCDBCEB] DEFAULT (getdate()) FOR [hire_date],
 CONSTRAINT [PK_emp_id] PRIMARY KEY  NONCLUSTERED
 (
  [emp_id]
 )  ON [PRIMARY] ,
 CONSTRAINT [CK_emp_id] CHECK ([emp_id] like '[A-Z][A-Z][A-Z][1-9][0-9][0-9][0-9][0-9][FM]' or [emp_id] like '[A-Z]-[A-Z][1-9][0-9][0-9][0-9][0-9][FM]')
GO

ALTER TABLE [dbo].[employee] ADD
  FOREIGN KEY
 (
  [job_id]
 ) REFERENCES [dbo].[jobs] (
  [job_id]
 ),
  FOREIGN KEY
 (
  [pub_id]
 ) REFERENCES [dbo].[publishers] (
  [pub_id]
 )
GO