CODEWITHSUNDEEP
sql
Mahlatse Tema
Mahlatse Tema

Reputation: 13

I'm getting a 'Incorrect syntax near"

"Incorrect Syntax near')'" error:

when creating the table below:

    create table branch_supplier (
    branch_id int,
    supplier_name varchar(40),
    supply_type varchar(40),
    primary key(branch_id, supplier_name)

What could be the problem. I'm a beginner in SQL

Upvotes: 1

Views: 56

Answers (1)

HereGoes
HereGoes

Reputation: 1320

You need an ending ')'

create table branch_supplier ( branch_id int, supplier_name varchar(40), supply_type varchar(40), primary key(branch_id, supplier_name))

Upvotes: 2

Related Questions