Post reply

Index and Key default naming standards

  • February 28, 2003 at 11:42 am

    #80840

    When creating indexes and keys on a table, SQL Server 2000 will automagically concantinate a 'PK_' prefix with the table name, ex: PK_Customer. My company wants a differenct format, Cutomer_PK. Is there a way to change the SQL Server default instead of manually changing the key/index name everytime you a key or index is created?

  • March 3, 2003 at 12:16 pm

    #450155

    Not that I know of. Just my opinion, in most cases the names don't matter at all unless you're using index hints. Can see where it would be nice. Nicer still if it asked you if you wanted to update the index name if you changed its make up.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

    Andy
    Connect with me on LinkedIn

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

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