CREATETABLE[dbo].[VWTaskCategories] ( [TaskCategoryID][int]NOTNULLIDENTITY(1,1), [Category][varchar](255)COLLATESQL_Latin1_General_CP1_CI_ASNOTNULL )ON[PRIMARY] GO ALTERTABLE[dbo].[VWTaskCategories]ADDCONSTRAINT[PK_VWTaskCategories]PRIMARYKEYCLUSTERED([TaskCategoryID])ON[PRIMARY] GO