Post reply

Default Key - Clustered or Non?

  • May 14, 2007 at 12:38 am

    #174332

    Hi All,

    If I ran the following statement what type of primary key would it create and can this be altered in the settings?

    CREATE TABLE EMP_DETAILS (EMPLOYEE_ID INT PRIMARY KEY, EMPLOYEE_NAME VARCHAR(25),

    DOJ DATETIME, DEPT_ID INT, SALARY INT);

    Thanks.

  • May 14, 2007 at 2:47 am

    #706140

    clustered

    you can check on the index (+) thingy on the table in QA

    Everything you can imagine is real.

  • May 15, 2007 at 1:12 am

    #706416

    It will create a unique clustered non-null index. A primary key must be non-null and must be unique, however, you can add the keyword nonclustered if you don't want it clustered. Like so:

    CREATE TABLE EMP_DETAILS (EMPLOYEE_ID INT nonclustered PRIMARY KEY,  EMPLOYEE_NAME VARCHAR(25),

    DOJ DATETIME, DEPT_ID INT, SALARY INT);

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply