How do I resolve this? Bothe tables are created in the database as you can see on the left.

Transcribed Image Text:

Object Explorer Connect Edfrein Edhernandez6 DJAMES7 0 djordan16 dlayne1 DMALONE7 dnenadovich DPEEK DSTEWART30 dwoodcock1 EANDERSON24 ebarner1 ebarnett4 Bebertram BEBINION1 th E Database Diagrams: E Tables System Tables FileTables External Tables Graph Tables dbo.EMPLOYEE Edbo.REGION Edbo.STORE - SQLQuery3.sql ap...N1 (ebinion1 (54))* ECREATE TABLE STORE 100 % SQLQuery2.sql-ap...N1 (ebinion1 (52))*XSQL Query1.sql ap...N1 (ebinion1 (56))* STORE CODE CHAR (4) PRIMARY KEY, STORE_NAME VARCHAR(15) NOT NULL, REGION_CODE CHAR(2), EMP_CODE CHAR (4), STORE YTD SALES CHAR(10), FOREIGN KEY (REGION_CODE) REFERENCES REGION (REGION_CODE), FOREIGN KEY (EMP_CODE) REFERENCES EMPLOYEE (EMP_CODE) ); Messages Mag 2714, Level 16, State 6, Line 1 There is already an object nad 'STORE' in the database. Completion time: 2023-02-26T11:08:08.2532866-06:00 + Object Explorer Connect Edfrein Edhernandez6 DJAMES7 0 djordan16 dlayne1 DMALONE7 dnenadovich DPEEK DSTEWART30 dwoodcock1 EANDERSON24 ebarner1 ebarnett4 Bebertram BEBINION1 th E Database Diagrams: E Tables System Tables FileTables External Tables Graph Tables dbo.EMPLOYEE Edbo.REGION Edbo.STORE - SQLQuery3.sql ap...N1 (ebinion1 (54))* ECREATE TABLE STORE 100 % SQLQuery2.sql-ap...N1 (ebinion1 (52))*XSQL Query1.sql ap...N1 (ebinion1 (56))* STORE CODE CHAR (4) PRIMARY KEY, STORE_NAME VARCHAR(15) NOT NULL, REGION_CODE CHAR(2), EMP_CODE CHAR (4), STORE YTD SALES CHAR(10), FOREIGN KEY (REGION_CODE) REFERENCES REGION (REGION_CODE), FOREIGN KEY (EMP_CODE) REFERENCES EMPLOYEE (EMP_CODE) ); Messages Mag 2714, Level 16, State 6, Line 1 There is already an object nad 'STORE' in the database. Completion time: 2023-02-26T11:08:08.2532866-06:00 +

Answer rating: 100% (QA)

First you need to remove the previous STORE table For that wr... View the full answer