Use Atlantic;
GO
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'usp_Create_Atlantic_Employees_Table') AND type = 'P')
DROP PROCEDURE dbo.usp_Create_Atlantic_Employees_Table;
GO
CREATE PROCEDURE usp_Create_Atlantic_Employees_Table
AS
CREATE TABLE AtlanticEmployees
(
emp_id INT IDENTITY
, emp_Name NVARCHAR(100)
, emp_Sal DECIMAL (10,2) CHECK (emp_Sal > 0)
, CONSTRAINT PK_AtlanticEmployees PRIMARY KEY (emp_id)
);