Results 1 to 3 of 3

Thread: Alter Table

  1. #1
    Join Date
    Nov 2002
    Posts
    10

    Unhappy Unanswered: Alter Table

    Hi All!

    Is it possible to change an existing field ("Customer#") in a table ("Order") to be a primary key using ALTER TABLE statement along with the CONSTRAINT clause? I've been trying to no avail.

    Any help is highly appreciated.

    Thanks!

  2. #2
    Join Date
    Nov 2002
    Posts
    10
    Also, there are no other indexed fields on this table.

    Again thanks for any help!

  3. #3
    Join Date
    Jul 2003
    Posts
    48
    ALTER TABLE tblOrder
    ALTER COLUMN CustomerNo Long
    CONSTRAINT PriKey PRIMARY KEY;

    Is this what you wanted?

Posting Permissions

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