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

Create table

SQL syntax

With one SQL statement you create the table, and all the columns: 		Introduction 1. Scope 2. Logical Design 3. Technical Optimisation
4. Implementation
Various DBMSses
Create table
Extra column Create index End
Create Table syntax

( Column specification )

Example

CREATE TABLE subscription
( taxNumber INT not null, newspaperName VARCHAR (35) not null)

Tips

  • Put fields with a fixed length in front.
  • Put the largest varchar field at the back.
  • Try to keep the columns in a logical sequence.
Next: Extra column