CREATETABLE[dbo].[CMContactMethods] ( [ContactMethodID][int]NOTNULL, [ContactMethod][varchar](50)COLLATESQL_Latin1_General_CP1_CI_ASNOTNULL )ON[PRIMARY] GO ALTERTABLE[dbo].[CMContactMethods]ADDCONSTRAINT[PK__CMContac__0BC859BB45325BAF]PRIMARYKEYCLUSTERED([ContactMethodID])ON[PRIMARY] GO