Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2006
    Posts
    1

    Unanswered: Defining a clustered key

    SQL server 2000: I'm told I need to define a clustered key on an existing table Scores for the rows absID and revID.

    what is the syntax for this? I'm looking online but not finding it.

    thanks.

    Dave

  2. #2
    Join Date
    Sep 2006
    Posts
    6
    Your best bet is to open up Query Analyzer, then hit F1.

    Then search for "clustered index key"

    BOL is your FRIEND.

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Do it through Enterprise Manager.

    Right-click on the table and select "Design Table".
    From the menu-bar, click the icon for "Manager Indexes/Keys" (second from right, normally).
    Click "New" to create a new index. Select the column(s) you want to include, and check off the box for "Create as clustered". Save and exit.

    Who told you the table needed this clustered index? Does the table have a primary key? (Normally the primary key is the clustered index.)
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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