如何在ORACLE 10g的同一行CREATE TABLE语句中添加多个约束? [英] How to add multi constraint in the same line of CREATE TABLE Statement in ORACLE 10g?
本文介绍了如何在ORACLE 10g的同一行CREATE TABLE语句中添加多个约束?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
朋友们,您好。
如何在ORACLE 10g的CREATE TABLE语句中的同一行中添加两个或更多约束,我已经尝试过这个语句但是它失败了:
CREATE TABLE学生(
ID INT PRIMARY KEY,
NAME VARCHAR2(50),
SOCIAL VARCHAR2(10)NOT NULL CHECK(社交('单身','已婚'))
);
但它不起作用。
我也不能在表格中制作复合键!!!
解决方案
< blockquote>尝试:
CREATE TABLE 学生(
ID INT ,
NAME VARCHAR2( 50 ),
SOCIAL VARCHAR2( 10 ) NOT NULL CHECK (SOCIAL IN (' Single',' 结婚')),
CONSTRAINT students_pk PRIMARY KEY (id,name)
)
;
Hello, friends.
How can I add two or more constraints in the same line in CREATE TABLE Statement in ORACLE 10g, I've tried this statement but it's failed:
CREATE TABLE Students(
ID INT PRIMARY KEY,
NAME VARCHAR2(50),
SOCIAL VARCHAR2(10) NOT NULL CHECK (SOCIAL IN ('Single','Married'))
);
but it doesn't work.
Also I can't make a composite key in the table!!!
解决方案
Try:
CREATE TABLE Students( ID INT, NAME VARCHAR2(50), SOCIAL VARCHAR2(10) NOT NULL CHECK (SOCIAL IN ('Single','Married')), CONSTRAINT students_pk PRIMARY KEY (id,name) ) ;
这篇关于如何在ORACLE 10g的同一行CREATE TABLE语句中添加多个约束?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文