Search notes:
SQL table
A table is a container that is able to store a zero or more rows (records).
Each row consists of one or more values (which might be
null
). Every row in a table hat the same number of values. This number is also referred to as
degree of a table
.
The data in rows is manipulated with
DML (= Data Manipulateion Language)
staements.
A row is also the smallest unit that can be added to a table (
insert
statement
or removed from a table
SQL: delete statement
A table is created with the
create table
and destroyed with the
drop table
statement.
See also
Table constraints
enforce
integrity rules
on a table.
A
trigger
allows to specifies a series of statements to be executed when records are inserted, deleted or updated on a table.
Data structures
The
SAS data set
and the
R data frame
.
Index