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

What is ibm db2 database?

1016


What is plan in cobol db2?

1146


What is db2 catalog database?

1050


What is bind in db2?

1055


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

1176


What is scrollable cursor in db2?

1059


How can deadlocks be resolved?

946


Give the name of some fields form sqlca.

1092


What is the difference between using bind () and rebind () methods of naming class?

1408


Highlight all the advantages that are attached to a package.

1124


What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1278


by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9232


What is temporal table in db2?

1047


What is cursor with hold option in db2?

1093


Is db2 a mainframe?

1053