    --创建表 EmployeeTerritories 的SQL语句
    CREATE TABLE EmployeeTerritories(
    		[EmployeeID] [int] NOT NULL,    --雇员ID
		[TerritoryID] [nvarchar](20) NOT NULL    --领域ID
		--key
        CONSTRAINT [PK_EmployeeTerritories] PRIMARY KEY CLUSTERED ([EmployeeID])
      
        CONSTRAINT [PK_EmployeeTerritories] PRIMARY KEY CLUSTERED ([TerritoryID])
      
    )
   --添加表注释
  exec sp_addextendedproperty N'MS_Description', N'表格备注', N'user', N'dbo', N'table', N'EmployeeTerritories'

   --添加列注释
   
   exec sp_addextendedproperty N'MS_Description', N'雇员ID', N'user', N'dbo', N'table', N'EmployeeTerritories', N'column', N'EmployeeID'
   exec sp_addextendedproperty N'MS_Description', N'领域ID', N'user', N'dbo', N'table', N'EmployeeTerritories', N'column', N'TerritoryID'