Execute create table in the Management Portal

Question

Question

Yuri Marx · Jul 18, 2020

Is it possible execute create table from management portal?

I tried this:

CREATE TABLE SQLUser.Teste(ID INT NOT NULL, coluna1 VARCHAR(255), coluna2 VARCHAR(255), coluna3 VARCHAR(255), coluna4 VARCHAR(255)CONSTRAINT TestePK PRIMARY KEY (ID))

Error message:

Discussion (3)1

Log in or sign up to continue

Robert Cemper · Jul 18, 2020

try it without "CONSTRAINT TestePK PRIMARY KEY (ID)"
and without "ID INT NOT NULL, "
so you get an autoincremented unique ID by default

2 0

score 0 · Answer 1 · 2020-07-18T16:27:03-04:00

Yuri Marx · Jul 18, 2020

Thanks!!!

0 0

score 0 · Answer 2 · 2021-04-22T07:05:06-04:00

Bumping into this question... almost a year late :-)... that query had a sintax error... you should put a comma before constraint.

In any case, Robert answer is also OK... unless you don't want ID to be autoincremental but to decide which value should go in it for each row.