Question

This script isn't working with SQL Server 2012, It keeps giving me an error of: There is already an object named 'CustomerID' in the database.

PLEASE HELP- What do I need to do?????

CREATE TABLE [CustomerID] (
[CustomerID] int,
[LastName] varchar(25),
[FirstName] varchar(25),
[PhoneNumber] varchar(10),
[Address] varchar(75),
[City] varchar(25),
[Zip] int,
[ServiceTicketID] int,
PRIMARY KEY ([CustomerID])
);

CREATE INDEX [FK] ON [CustomerID] ([ServiceTicketID]);

CREATE TABLE [ServiceTicket] (
[ServiceTicketID] int,
[DateOfService] varchar(25),
[Notes] varchar(100),
[CustomerID] int,
[PartsUsedID] int,
PRIMARY KEY ([ServiceTicketID])
);

CREATE INDEX [FK] ON [ServiceTicket] ([CustomerID], [PartsUsedID]);

CREATE TABLE [PartsUsed] (
[PartsUsedID] int,
[PartID] int,
[PriceOfPart] int,
[NumberOfPartsUsed] int,
[CustomerID] int,
[ServiceTicketID] int,
PRIMARY KEY ([PartsUsedID])
);

CREATE INDEX [FK] ON [PartsUsed] ([CustomerID], [ServiceTicketID]);

Answer 1

If you have any doubts, please give me comment...

DROP TABLE IF EXISTS Customer;

DROP TABLE IF EXISTS ServiceTicket;

DROP TABLE IF EXISTS PartsUsed;

CREATE TABLE [Customer] (

    [CustomerID] int,

    [LastName] varchar(25),

    [FirstName] varchar(25),

    [PhoneNumber] varchar(10),

    [Address] varchar(75),

    [City] varchar(25),

    [Zip] int,

    [ServiceTicketID] int,

    PRIMARY KEY ([CustomerID])

);

CREATE INDEX [Customer_FK] ON [Customer] ([ServiceTicketID]);

CREATE TABLE [ServiceTicket] (

    [ServiceTicketID] int,

    [DateOfService] varchar(25),

    [Notes] varchar(100),

    [CustomerID] int,

    [PartsUsedID] int,

    PRIMARY KEY ([ServiceTicketID])

);

CREATE INDEX [ServiceTicket_FK] ON [ServiceTicket] ([CustomerID], [PartsUsedID]);

CREATE TABLE [PartsUsed] (

    [PartsUsedID] int,

    [PartID] int,

    [PriceOfPart] int,

    [NumberOfPartsUsed] int,

    [CustomerID] int,

    [ServiceTicketID] int,

    PRIMARY KEY ([PartsUsedID])

);

CREATE INDEX [PartsUsed_FK] ON [PartsUsed] ([CustomerID], [ServiceTicketID]);