Written by

Software Architect at Visum

Question Yuri Marx · Jul 18, 2020

Execute create table in the Management Portal

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

Add reply

Comments

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

0 0

Yuri Marx Jul 18, 2020 to Robert Cemper

Thanks!!!

0 0

Jose-Tomas Salvador · Apr 22, 2021

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.

0 0