Answer posted by Dba is correct. But in real time schenario we should be m

How we create a tables in db2,what is the process/syntax to
create a table with example plz?

Question Posted / ratheesh nellikal

2 Answers
15354 Views
I also Faced
E-Mail Answers

Answer posted by Dba is correct.
But in real time schenario we should be more specific.
eg:
CREATE TABLE SCHEMA.TABLENAME
(column1 DATATYPE,
column2 DATATYPE,
column3 DATATYPE)
IN tablespace_name
INDEX IN index_tablespace;

so try to follow this syntax (u can have more options with
this command like u can even specify the tablespace name wr
do u want to store ur LONG object 'LONG IN
long_tablespace' )

Cheers,
Ratheesh Nellikal

Is This Answer Correct ?

6 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the rules for db2 programming?

1098

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1105

When reorg is used?

1134

What is catalog database in db2?

1172

How do I copy a table in db2?

1003

What is the picture clause of null indicator variable?

1138

What is dbrm in db2 database?

1122

What are union and union all?

983

What is plan in cobol db2?

1141

Define check constraint.

1083

What is difference between isnull and coalesce?

1059

How do I delete a table in db2?

1081

What is the max length of sqlca?

1218

What is the information associated with sysibm.syslinks table?

1126

How to take backup of table in db2?

1079