Index naming conventions? 4

[jordanking]

Hello,

I have an application that is being created from the ground up. I was just wondering if there is any naming conventions you would suggest specifically for indexes.

Here is a link to a website that might begin the discussion.

http://www.ssw.com.au/ssw/Standards/DeveloperSQLServer/SQLServerStandard_4_IndexesNaming.aspx

Thanks in advnace.

JK



JK

I'd rather be surfing

 

[SQLSister]

Personally I use
IX_tablename_FieldsinIndex

"NOTHING is more important in a database than integrity." ESquared

 

[ESquared]

I use that too

IX_Table_Column1_Column2_Column3

 

[mrdenny]

I use the same syntax as well.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[gmmastros]

I use a very similar syntax.

idx_table_column1_column2



-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[jordanking]

thanks everyone,

JK



JK

I'd rather be surfing