SQL to create

Results 1 to 2 of 2

Thread: SQL to create

  1. #1
    Join Date
    Dec 1969

    Default SQL to create

    I need the SQL to create a new table and fields on an MS-SQL2000 server.<BR><BR>so far I have <BR><BR>SQL="CREATE TABLE Articles(id INTEGER, section CHAR(20), title CHAR(100), update SMALLDATETIME, author CHAR(20), hits INTEGER, prints INTEGER, emails INTEGER, content TEXT" <BR><BR>How do i set the primary key to the id field in SQL???<BR>How do I set this id field as an autonumber field<BR><BR>And any other advice would be nice<BR><BR>Many thanks<BR><BR>

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: SQL to create

    "CREATE TABLE Articles(id INTEGER primary key identity(1,1),....<BR><BR><BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts