Hello Mike,
The Standard format for this is to have the Qualifier after the object type abbreviation. So for example the SQL objects and supported formats are:
Unique Constraint:
IX_{objectQualifier}ObjectName
Primary Key:
PK_{objectQualifier}ObjectName
Foreign Key:
FK_{objectQualifier}ObjectName
Default Constraint:
DF_{objectQualifier}ObjectName
Tables, Stored Procedures & Views:
{objectQualifier}ObjectName
If you look at the example on this page in the wiki:
http://www.dotnetnuke.com/Resources/W...You can see why this makes sense, in that example while creating a primary key on the table, the standard naming convention (used when auto generating scripts from SSMS) is to do PK_TableName. As you can see in the example, the Table name is {objectQualifier}DNNSimpleArticle_Article so the primary key for that table would be named PK_{objectQualifier}DNNSimpleArticle_Article.
Please let me know if you have any other questions.
Cheers,
Nathan Rover