索引和约束

最新推荐文章于 2024-05-23 10:15:00 发布

wentao365

最新推荐文章于 2024-05-23 10:15:00 发布

阅读量523

点赞数

分类专栏： oracle

本文链接：https://blog.csdn.net/wentao365/article/details/83739325

版权

oracle 专栏收录该内容

42 篇文章 0 订阅

订阅专栏

1.XUECI_CIKU_DANCI:

[img]http://dl.iteye.com/upload/attachment/339526/3782380b-eb6f-39f9-bf34-4324dbdd1cfe.png[/img]

2:KEYS:

[img]http://dl.iteye.com/upload/attachment/339528/9cf05a22-b383-3fd7-b46c-b00f488311c3.png[/img]

3:CHECKS:

[img]http://dl.iteye.com/upload/attachment/339530/c2827279-722d-3968-bf87-91542490211f.png[/img]

4:INDEXES:

[img]http://dl.iteye.com/upload/attachment/339532/b25f2157-3168-3102-bdea-e84d770891f5.png[/img]

5.主键约束：
[quote]
alter table XUECI_CIKU_DANCI
add constraint PK_XUECI_CIKU_DANCI primary key (ID)
using index
tablespace XUECI
pctfree 10
initrans 2
maxtrans 255;
[/quote]

6.外键约束：
[quote]
alter table XUECI_CIKU_DANCI
add constraint FK_CIKU_DANCI_CIKU foreign key (CIKU_ID)
references XUECI_CIKU (ID);

alter table XUECI_CIKU_DANCI
add constraint FK_CIKU_DANCI_DANCI foreign key (DANCI_ID)
references XUECI_DANCI (ID);
[/quote]

7：索引：
[quote]
create index INDEX_XUECI_CIKU_DANCI_CIKUID on XUECI_CIKU_DANCI (CIKU_ID)
tablespace XUECI
pctfree 10
initrans 2
maxtrans 255;

create index INDEX_XUECI_CIKU_DANCI_DANCIID on XUECI_CIKU_DANCI (DANCI_ID)
tablespace XUECI
pctfree 10
initrans 2
maxtrans 255;

create bitmap index INDEX_XUECI_CIKU_DANCI_STATUS on XUECI_CIKU_DANCI (STATUS)
tablespace XUECI
pctfree 10
initrans 2
maxtrans 255;
[/quote]