getting syntax error while altering column in sql [duplicate]

Question

Trying to add UNIQUE attribute to existing column, getting syntax error

smartbrain=# ALTER TABLE users ALTER COLUMN email VARCHAR(100) UNIQUE NOT NULL;

ERROR:  syntax error at or near "VARCHAR"
LINE 1: ALTER TABLE users ALTER COLUMN email VARCHAR(100) UNIQUE NOT...

paulsm4 · Accepted Answer · 2020-07-24 17:50:20Z

0

If "users" already has column "email", and the data type is already "varchar(100)", then try this:

ALTER TABLE users
  ADD  UNIQUE (email);

ALTER TABLE users
  ALTER COLUMN email set NOT NULL;

edited Jul 24, 2020 at 17:50

answered Jul 24, 2020 at 17:44

paulsm4

123k23 gold badges175 silver badges245 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

getting syntax error while altering column in sql [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related