There is no error in that stored procedure, however if you run it more than once you will get a runtime error
Quote:
Msg 2714, Level 16, State 6, Procedure PackageMaster, Line 3
There is already an object named 'tbl_PackageMaster' in the database.
You need to see if the table already exists first .. e.g. if you want to drop it if it already exists you could use
create PROCEDURE PackageMaster
AS
BEGIN
IF (EXISTS (SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE -- TABLE_SCHEMA = 'YourSchema' and
TABLE_NAME = 'tbl_PackageMaster'))
DROP TABLE tbl_PackageMaster
CREATE TABLE tbl_PackageMaster
(
Pkg_ID INT PRIMARY KEY NOT NULL,
Pkg_Internal_ID INT IDENTITY(1,1),
Pkg_Name NVARCHAR(MAX),
Pkg_description VARCHAR(MAX),
Pkg_Image1 VARCHAR(MAX),
Pkg_Adv_Book_Days INT,
Pkg_time_from DATETIME,
Pkg_time_to DATETIME,
Pkg_basic_guest_no INT,
Pkg_hours_included INT,
Pkg_Distance_Covered INT
)
END
or if you only want to create it if it doesn't exist you could use
CREATE PROCEDURE PackageMaster
AS
BEGIN
IF (NOT EXISTS (SELECT *
FROM INFORMATION_SCHEMA.TABLES
WHERE -- TABLE_SCHEMA = 'YourSchema' and
TABLE_NAME = 'tbl_PackageMaster'))
CREATE TABLE tbl_PackageMaster
(
Pkg_ID INT PRIMARY KEY NOT NULL,
Pkg_Internal_ID INT IDENTITY(1,1),
Pkg_Name NVARCHAR(MAX),
Pkg_description VARCHAR(MAX),
Pkg_Image1 VARCHAR(MAX),
Pkg_Adv_Book_Days INT,
Pkg_time_from DATETIME,
Pkg_time_to DATETIME,
Pkg_basic_guest_no INT,
Pkg_hours_included INT,
Pkg_Distance_Covered INT
)
END