create table statement error

• paul-144416

  SSC Veteran

  Points: 221

  More actions

  August 12, 2004 at 8:55 am

  #109029

  Hi

  when I run the following statement in the query analyser, I get an error :

  [Microsoft][ODBC SQL Server Driver]Syntax error or access violation

  here is the statement :

  CREATE TABLE [dbo].[tblGroups] {

   drgrpid int IDENTITY (1, 1) 

                   PRIMARY KEY  CLUSTERED ,

   drgroup varchar (100)  NOT NULL ,

   drlongcode varchar (100)  NOT NULL ,

          drattr_1 varchar (50)  NOT NULL ,

          drattr_2 varchar (50)  NOT NULL  }

  any ideas as to why this is happening ?

  thanks

• Henrik M

  Valued Member

  Points: 62

  More actions

  August 12, 2004 at 9:10 am

  #518701

  Replace the brackets with parenthesis

  /hm

• paul-144416

  SSC Veteran

  Points: 221

  More actions

  August 13, 2004 at 1:07 am

  #518804

  thanks !

• conrad coetzee

  SSC Enthusiast

  Points: 112

  More actions

  August 13, 2004 at 4:27 am

  #518828

   

  or replace {}  with ()

  CREATE TABLE [dbo].[tblGroups] (

   drgrpid int IDENTITY (1, 1) 

                   PRIMARY KEY  CLUSTERED ,

   drgroup varchar (100)  NOT NULL ,

   drlongcode varchar (100)  NOT NULL ,

          drattr_1 varchar (50)  NOT NULL ,

          drattr_2 varchar (50)  NOT NULL  )