Results 1 to 3 of 3

Thread: Create Table Query

  1. 07-15-2003, 01:59 PM #1
    anthonykchoi
    anthonykchoi is offline Registered User
    Join Date
    Jun 2003
    Posts
    24

    Create Table Query

    I am trying to figure out how to insert an autonumber field into a Create Table Query.

    Thanks!
    Reply With Quote Reply With Quote
  2. 07-15-2003, 11:14 PM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    create table mytable (ID1 AUTOINCREMENT,name text)
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 07-15-2003, 11:17 PM #3
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    Query1:
    create table xyz (name text);

    Query2:
    ALTER TABLE xyz ADD COLUMN recno AUTOINCREMENT;
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules