This is a continuation from my last post... I am trying to create a table using the following code
/*Agent's commission rates*/
/*Drop and Create MySQL-formatted table*/
IF OBJECT_ID( N'dbo.agent_rates' ) IS NOT NULL
DROP TABLE dbo.agent_commissions;
CREATE TABLE dbo.agent_commissions
(agent_id INT NOT NULL , product_id VARCHAR(6) NOT NULL ,
family DECIMAL(5,2) NOT NULL , adult DECIMAL(5,2) NOT NULL , senior DECIMAL(5,2) NOT NULL ,
student DECIMAL(5,2) NOT NULL , child DECIMAL(5,2) NOT NULL , infant DECIMAL(5,2) NOT NULL);
But I keep getting
Msg 2714, Level 16, State 6, Line 9
There is already an object named 'agent_commissions' in the database.
However, isn't this taken care of on lines 6-7?