DB 2 Tutorial

DB2 RazorSQL GUI DB2 is little bit complicated to use at command line. You can use it GUI by downloading RazorSQL. What…

DB2 Datatypes In DB2 Database tables, each column has its own data type depending on developer’s requirements. The data type is said…

Deactivate a Database The “deactivate db” command is used to stop the database services. Syntax: db2 deactivate db Here, db_name specifies the…

DB2 RazorSQL Describe Describe is used to show information about columns names, their datatypes, size, primary key, foreign key, nullable, scale etc.…

DB2 RazorSQL View Contents (Fetch All Rows) As the name specified, it is used to see all the rows of the table.…

Drop Bufferpool You can drop a bufferpool by using “drop bufferpool” command. It is suggested to check if any tablespace is assigned…

DB2 RazorSQL Drop Table This is used to delete the total tables in a schemas. Next TopicExport Data

DB2 RazorSQL View Contents (Limit Results) View Contents limit result is used to see limited results only. You can see first 10…

Drop Database The drop database command is used to remove your database from instant database directory. It will delete all its objects,…

DB2 RazorSQL Drop The Drop command is used to delete tables from databases and different schemas. Let’s drop the table “STUDENTS” from…