sql server stuff

CREATE TABLE EMPLOYEE ( EMPID INT IDENTITY(1,1), EMPNAME VARCHAR(500) ) ALTER TABLE EMPLOYEE ADD CONSTRAINT PK_EMPLOYEE_EMPID PRIMARY KEY (EMPID) ALTER TABLE EMPLOYEE ALTER COLUMN EMPNAME VARCHAR(501) CREATE INDEX IX_EMPLOYEE_EMPNAME ON EMPLOYEE (EMPNAME)