Interested to Buy Any Domain ? << Click Here >> for more details...
How we create a tables in db2,what is the process/syntax to
create a table with example plz?
- 2 Answers
- 15307 Views
- I also Faced
- E-Mail Answers
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
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is the difference between oracle and db2?
What is the difference between cursor and select statement?
Where can you declare a cursor in a cobol-db2 program?
What are foreign keys in db2?
What is the syntax for creating a table in the db2 database?
Is db2 free?
Mention the location where the output received from explain statement is stored.
Is ibm db2 open source?
What is buffer pool and list some of them?
Is db2 a database?
What is database manager in db2?
Outputs of explain are with matchcols = 0. What does this signify?
What are the different types of base tables?
What is bind package and plan in db2?
