Chapter 14 – Table Create and Data Types

“Create a definite plan for carrying out your desire and begin at once, whether you are ready or not, to put this plan into action. “

- Napoleon Hill

The Basics of Creating a Table

image

At the bare minimum, you must include the tablename, along with the column names and their data types, to create a table.

Creating a Table with NOT NULL Constraints

image

A column that does not allow NULLs has a NOT NULL constraint, and it does not accept rows with no value for that column. By default, all columns can be Nullable unless ...

Get Tera-Tom Genius Series - DB2 SQL now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.