Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

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

Is it possible using max on a char column?

1100


Can there be more than one cursor open for any program?

1143


What is sqlca?

1022


How can deadlocks be resolved?

907


What does db2 mean?

969


What is null in db2?

972


Who uses db2?

997


How is deadlock resolved?

1100


How many types of page locks can be held in db2?

1007


What is innodb buffer pool?

1004


Explain about dbrm.

1005


What is meant by explain?

1083


What parameters are used to control the free space in DB2?

1025


How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1199


What is reorg?

1096