Create table

SQL syntax

With one SQL statement you create the table, and all the columns:
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.