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 '[AZ] [ AZ] [AZ] [1-9] [0-9] [0-9] [fm] 'or [EMP_ID] LIKE' [AZ] - [AZ] [1- 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] )
