The following are my code standards, broken up by C#, and SQL, and should be listed alphabetically. This will be a growing and updated document.
/* Foreign Key */ ALTER TABLE [Schema].[ForeignKeyTable] ADD CONSTRAINT FK_ForeignKeyTable_PrimaryKeyTable FOREIGN KEY ( ForeignKeyColumn ) REFERENCES [Schema].[PrimaryKeyTable] ( PrimaryKeyColumn ) ON UPDATE NO ACTION ON DELETE NO ACTION GO /* Primary Key */ ALTER TABLE [Schema].[Table] ADD CONSTRAINT PK_Table PRIMARY KEY CLUSTERED ( IdentityColumn ) WITH ( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON ) ON [PRIMARY] GO