Create a DB2 Table

Create a DB2 Table

How to create a DB2 Table?

The following query can be used to create a DB2 table

CREATE TABLE Table_Name

(

Column_one datatype,

column_two datatype

:

:

)

An example is shown below

CREATE TABLE Emp_Table

(

Emp_Number CHAR(10) NOT NULL WITH DEFAULT,

Emp_Salary DECIMAL(10,0) NOT NULL WITH DEFAULT,

Emp_Sec_code SMALLINT NOT NULL WITH DEFAULT

)

; ; ; ;