how can I change the varchar length of varchar from (30) to (70) in sql [closed]

Question

Navigation

#1 by (2 votes)
#2 by (0 votes)

0

create table catalogo 
(nodecuenta varchar (12) primary key, 
descripcion varchar (40)  not null)

sql-server

asked by Angel Rodriguez Aguirre 30.10.2018 в 03:02

source

2 answers

score 2 · Answer 1

2

As follows:

Do not forget to always mention the table and the field to be modified:

ALTER TABLE catalogo MODIFY COLUMN descripcion VARCHAR(70);

answered by 30.10.2018 в 03:09

score 0 · Answer 2

0

Try this code

ALTER TABLE catalogo
CHANGE COLUMN descripcion
descripcion VARCHAR(70) NOT NULL;

answered by 30.10.2018 в 03:08