    --创建表 CustomerCustomerDemo 的SQL语句
    CREATE TABLE CustomerCustomerDemo(
    		[CustomerID] [nchar](5) NOT NULL,    --客户ID
		[CustomerTypeID] [nchar](10) NOT NULL    --客户类型ID
		--key
        CONSTRAINT [PK_CustomerCustomerDemo] PRIMARY KEY CLUSTERED ([CustomerID])
      
        CONSTRAINT [PK_CustomerCustomerDemo] PRIMARY KEY CLUSTERED ([CustomerTypeID])
      
    )
   --添加表注释
  exec sp_addextendedproperty N'MS_Description', N'表格备注', N'user', N'dbo', N'table', N'CustomerCustomerDemo'

   --添加列注释
   
   exec sp_addextendedproperty N'MS_Description', N'客户ID', N'user', N'dbo', N'table', N'CustomerCustomerDemo', N'column', N'CustomerID'
   exec sp_addextendedproperty N'MS_Description', N'客户类型ID', N'user', N'dbo', N'table', N'CustomerCustomerDemo', N'column', N'CustomerTypeID'