Board index » delphi » Create primary index with SQL?

Create primary index with SQL?

How does one go about creating a primary index in a paradox table using sql?
 

Re:Create primary index with SQL?


Quote
>Eric Lewis wrote:

>How does one go about creating a primary index in a paradox table
>using sql?

Using SQL, you can create a primary key only while creating a table:

  CREATE TABLE "newtable.db"
   (ID Autoinc,
    Name CHAR(30),
    ...,
    PRIMARY KEY (ID))
________
Andreas
Delphi 5.01 Pro, Win2K Sp2

Re:Create primary index with SQL?


Thanks

Other Threads