CREATETABLE[dbo].[LdJoinTypes] ( [JoinTypeID][int]NOTNULLIDENTITY(1,1), [JoinType][varchar](64)COLLATESQL_Latin1_General_CP1_CI_ASNOTNULL )ON[PRIMARY] GO ALTERTABLE[dbo].[LdJoinTypes]ADDCONSTRAINT[PK_LdJoinTypes]PRIMARYKEYCLUSTERED([JoinTypeID])ON[PRIMARY] GO