DB2 CREATE TABLE

Code Example

## DB2 CREATE TABLE

CREATE TABLE defines a new table structure.

### Basic Syntax
\`\`\`sql
CREATE TABLE table-name (
    column-name data-type [constraints],
    ...
) IN database.tablespace
\`\`\`

### Common Data Types
| Type | Description |
|------|-------------|
| CHAR(n) | Fixed length |
| VARCHAR(n) | Variable length |
| INTEGER | Whole number |
| DECIMAL(p,s) | Decimal number |
| DATE | Date value |
| TIMESTAMP | Date and time |

### Column Constraints
- NOT NULL
- DEFAULT value
- PRIMARY KEY
- FOREIGN KEY
- CHECK condition
- UNIQUE

### Table Constraints
\`\`\`sql
PRIMARY KEY (columns),
FOREIGN KEY (col) REFERENCES table(col),
CHECK (condition)
\`\`\`