do this please asap...........
do the marked ones
Attachments:
Answers
Answered by
0
Comparision OperatorsDescription. LIKE-column value is similar to specified character(s). IN-column value is equal to any one of a specified set of values. BETWEEN...AND-column value is between two values, including the end values specified in the range. IS NULL-column value does not exist.
Table Constraints
Description
Specifies a constraint for a table that restricts the values that the table can store. INSERT, UPDATE, or DELETE statements that violate the constraint fail. c-treeACE SQL returns a Constraint violation error.
Table constraints have syntax and behavior similar to column constraints. Note the following differences:
The syntax for table constraints is separated from column definitions by commas.
Table constraints must follow the definition of columns they refer to.
Table constraint definitions can include more than one column and c-treeACE SQL evaluates the constraint based on the combination of values stored in all the columns.
Syntax
table_constraint ::
PRIMARY KEY ( column [, ... ] )
| UNIQUE ( column [, ... ] )
| FOREIGN KEY ( column [, ... ] )
REFERENCES [ owner_name. ] table_name [ ( column [, ... ] ) ]
| CHECK ( search_condition )
Column constraints are restrictions on the data that can be inserted into a givencolumn. The following table describes thecolumn constraints. ... Denotes that thecolumn is a primary key for the table. The primary keys can be used to join related tables in a multiple table query.
Table Constraints
Description
Specifies a constraint for a table that restricts the values that the table can store. INSERT, UPDATE, or DELETE statements that violate the constraint fail. c-treeACE SQL returns a Constraint violation error.
Table constraints have syntax and behavior similar to column constraints. Note the following differences:
The syntax for table constraints is separated from column definitions by commas.
Table constraints must follow the definition of columns they refer to.
Table constraint definitions can include more than one column and c-treeACE SQL evaluates the constraint based on the combination of values stored in all the columns.
Syntax
table_constraint ::
PRIMARY KEY ( column [, ... ] )
| UNIQUE ( column [, ... ] )
| FOREIGN KEY ( column [, ... ] )
REFERENCES [ owner_name. ] table_name [ ( column [, ... ] ) ]
| CHECK ( search_condition )
Column constraints are restrictions on the data that can be inserted into a givencolumn. The following table describes thecolumn constraints. ... Denotes that thecolumn is a primary key for the table. The primary keys can be used to join related tables in a multiple table query.
Similar questions