www.sum-it.nl > Courses
> DB Design course > Method > 4. Implementation > Extra column		Previous Previous Next Next
Nederlands · Search...

Extra column

You can easily extend an existing table with an extra column:

SQL syntax

 Introduction 1. Scope 2. Logical Design 3. Technical Optimisation
4. Implementation
Various DBMSses Create table
Extra column
Create index End
ALTER TABLE table add

Column specification

Example

ALTER TABLE subscription ADD
trialSubscription CHAR (1) not null
Next: Create Index