# Creating a Table

```
create table r (A1 D1, A2 D2, ..., An Dn, IC1, IC2, ..., ICk)
```

* r is the name of the relation/table
* A1, A2, ..., An are attributes
* D1, D2, ..., Dn are the data types of values in the domains of the corresponding attributes
* IC1, IC2, ..., ICk are integrity constraints

Ex. the following creates a table for the instructor relation with primary and foreign key constraints

```
create table instructor (ID char(5), name varchar(20) not null, dept_name varchar(20), salary numeric(8, 2), 
                         primary key (ID), foreign key (dept_name) references department)
```

## Inserting Values

```
insert into r values (V1, V2, ..., Vn)
```