Sql Server Check约束 - MS-SQL Server / 基础类

表名：tb_star

字段：star_id　　　int
　　　star_name varchar(50)



写一个Check约束：要求star_name必须包含andy或jay　　　

---

建table ?
SQL code:
create table tb_star(

star_id int,
star_name varchar(50),
CONSTRAINT check_name CHECK (charindex('andy',star_name)>0 or charindex('jay',star_name)>0 )
)

---

SQL code:
create table tb_star(star_id int,star_name varchar(50) check(star_name like '%andy%' or star_name like '%jay%'))

---

SQL code:

--加check
Alter table tb_star add CONSTRAINT check_name CHECK (charindex('andy',star_name)>0 or charindex('jay',star_name)>0 )

---

SQL code:

CREATE TABLE tb_star(
star_id int NOT NULL,
star_name varchar(50) NOT NULL,
CONSTRAINT PK_tb_star PRIMARY KEY CLUSTERED(star_id),
CONSTRAINT CK_tb_star_star_name CHECK(star_name LIKE '%andy%' OR star_name LIKE '%jay%')
)

---

create table tb_star(

 star_id int,
 star_name varchar(50),