Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    33

    Unanswered: How to add 'Fill Factor' in the SQL script

    I am trying to set up the relationship (Primary Key and Forign Key) in several tables. I would like to find a way also be able to set 'Fill Factor = 90%' in the script. Here is the code that i have so far:

    ALTER TABLE Req
    ADD CONSTRAINT FK_Req_Bow FOREIGN KEY ( BowID )
    REFERENCES Bow ( BowID )

    Any help would be greatly appreciated!

    J827

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    FILLFACTOR pertains to an index that you need to create for your FOREGN KEY constraint, not to the constraint itself.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

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