title: Are foreign keys indexed automatically in SQL Server?
body: <p>Would the following SQL statement automatically create an index on Table1.Table1Column, or must one be explicitly created?</p>
  
  <p>Database engine is SQL Server 2000</p>
  
  <pre><code>       CREATE TABLE [Table1] (
  . . .
              CONSTRAINT [FK_Table1_Table2] FOREIGN KEY 
              (
                  [Table1Column]
              ) REFERENCES [Table2] (
                  [Table2ID]
              )
  
          )
  </code></pre>