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


Please Help Members By Posting Answers For Below Questions

what is the responsibility of the construction superintendent

1664


What is plan in cobol db2?

595


How can the duplicate values be eliminated from db2 select?

632


What is with ur in db2?

760


What is the maximum size of varchar data type in db2?

645






What are db2 tables?

649


How do I connect my db2 database to ibm?

602


How does cobol compile db2 program?

610


DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2279


How do I import a csv file into db2?

562


What is db2 look?

580


How do I add a column in db2?

595


What is bind plan?

613


What do you mean by commit and rollback?

595


What are the bind parameters ibm db2?

624