Table MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. Table
  4. Change the length of the emp_name column in the employee table from varchar(30) to varchar(50)
15>  CREATE TABLE employee
16> (
17> emp_id      int            NOT NULL PRIMARY KEY,
18> emp_name    varchar(30)    NOT NULL,
19> mgr_id      int            NOT NULL REFERENCES employee(emp_id)
20> )
21> GO
1>
2> ALTER TABLE employee
3> ALTER COLUMN emp_name varchar(50)
4> GO
1>
2> drop table employee;
3> GO
1>