How we create a tables in db2,what is the process/syntax to
create a table with example plz?
Answer Posted / dba
Its very much similar as we sue in other DB
Syntax: CREATE TABLE EMPLOYEE(EMP_ID CHAR(10), NAME VARCHAR(20))
The syntax is usful only in command center
But from GUI its more easier to create table
| Is This Answer Correct ? | 14 Yes | 5 No |
Post New Answer View All Answers
Is it possible using max on a char column?
Can there be more than one cursor open for any program?
What is sqlca?
How can deadlocks be resolved?
What does db2 mean?
What is null in db2?
Who uses db2?
How is deadlock resolved?
How many types of page locks can be held in db2?
What is innodb buffer pool?
Explain about dbrm.
What is meant by explain?
What parameters are used to control the free space in DB2?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is reorg?