12.6. Table Constraints

Constraints can be defined on table/view to define indexes and relationships to other tables/views. See "create table body" in Section A.7, “Productions”.

This information is used by the JBoss Data Virtualization optimizer to plan queries or use the indexes in materialization tables to optimize the access to the data.

CONSTRAINTS are same as one can define on RDBMS.

Example 12.4. Example of CONSTRAINTs

CREATE VIEW CustomerOrders (name varchar(50),  saledate date, amount decimal, 
   CONSTRAINT EXAMPLE_INDEX INDEX (name, amount)
   ACCESSPATTERN (name)
   PRIMARY KEY ...

CREATE VIEW CustomerOrders (name varchar(50),  saledate date, amount decimal, 
   CONSTRAINT EXAMPLE_INDEX INDEX (name, amount)
   ACCESSPATTERN (name)
   PRIMARY KEY ...

Copy to Clipboard

Toggle word wrap

返回顶部

此内容没有您所选择的语言版本。

12.6. Table Constraints

学习

尝试、购买和销售

社区

关于红帽文档

让开源更具包容性

關於紅帽

Theme

Red Hat legal and privacy links

Red Hat legal and privacy links