Question: I keep getting this error after trying to execute this Query. An error occurred when executing the SQL command: CREATE TABLE EMPLOYEEATTRITION ( ID_column INT

I keep getting this error after trying to execute this Query.

An error occurred when executing the SQL command: CREATE TABLE EMPLOYEEATTRITION ( ID_column INT NOT NULL IDENTITY(1,1) PRIMARY KEY, AGE INT, ATTRITION VARCHAR(20), BUSINESSTRAVEL VARCHAR(40),... Io exception: Operation timed out (Read failed) [DB Errorcode=17002] 1 statement failed. Execution time: 2m 32s

The query that I`m having trouble with is..

CREATE TABLE EMPLOYEEATTRITION ( ID_column INT NOT NULL IDENTITY(1,1) PRIMARY KEY, AGE INT, ATTRITION VARCHAR(20), BUSINESSTRAVEL VARCHAR(40), DAILYRATE INT, DEPARTMENT VARCHAR(20), DISTANCEFROMHOME VARCHAR(10), EDUCATION INT, EDUCATIONFIELD VARCHAR(20), EMPLOYEECOUNT INT, EMPLOYEENUMBER INT, ENVIRONMENTSATISFACTION INT, GENDER VARCHAR(10), HOURLYRATE INT, JOBINVOLVEMENT INT, JOBLEVEL INT, JOBROLE VARCHAR(30), JOBSATISFACTION INT, MARITALSTATUS VARCHAR(10), MONTHLYINCOME INT, MONTHLYRATE INT, NUMCOMPANIESWORKED INT, OVER18 CHAR(1), OVERTIME VARCHAR(5), PERCENTSALARYHIKE VARCHAR(5), PERFORMANCERATING INT, RELATIONSHIPSATISFACTION INT, STANDARDHOURS INT, STOCKOPTIONLEVEL INT, TOTALWORKINGYEARS INT, TRAININGTIMESLASTYEAR INT, WORKLIFEBALANCE INT, YEARSATCOMPANY INT, YEARSINCURRENTROLE INT, YEARSSINCELASTPROMOTION INT, YEARSWITHCURRMANAGER INT );

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!