Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
?
? asked in Computers & InternetProgramming & Design · 5 years ago

SQL create table not working. returns invalid identifier.?

create table NONGAME

(Column varchar(15) primary key,

Type varchar(15),

length decimal(2,0),

Decimal_places decimal(2,0),

Nulls_allowed varchar(15),

Description varchar(25)

);

2 Answers

Relevance
  • Jeff P
    Lv 7
    5 years ago

    What database server are you using? Different DBMSs have varying CREATE TABLE syntax.

  • Chris
    Lv 7
    5 years ago

    Column is an SQL keyword; if you want to use it in queries you need to use: `Column`

Still have questions? Get your answers by asking now.