CHECK on column emp_id|([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]')
DEFAULT on column hire_date|(getdate())
DEFAULT on column job_id|((1))
DEFAULT on column job_lvl|((10))
DEFAULT on column pub_id|('9952')
FOREIGN KEY|job_id
|REFERENCES pubs.dbo.jobs (job_id)
FOREIGN KEY|pub_id
|REFERENCES pubs.dbo.publishers (pub_id)
PRIMARY KEY (non-clustered)|emp_id
No foreign keys reference this table, or you do not have permissions on referencing tables.|