![](https://csdnimg.cn/release/download_crawler_static/87550119/bg3.jpg)
下面看一个实际,转自 WEB CAST
在服务器 A 创建表 CUSTOMERS
//ServerA
Use pubs
go
Create table customers (
Customerid varchar(5) not null,
CompanyName varchar(50) not null,
ContactName varchar(30) null,
CONSTRAINT PK_customers PRIMARY KEY CLUSTERED (Customerid),
CONSTRAINT CK_customerid CHECK (Customerid between 'AAAAA' and 'LZZZZ')
)
在服务器 B 也创建另一张表,表的结果,类型完全一样,注意表的 CHECK 不同。
(表名可以不同,但最好一样)
//Server B
use pubs
go
Create table customers (
Customerid varchar(5) not null,
CompanyName varchar(50) not null,
ContactName varchar(30) null,
CONSTRAINT PK_customers PRIMARY KEY CLUSTERED (Customerid),