DB 2 Tutorial

DB2 RazorSQL Show Info Show info is used to retrieve all information of the table. i.e. table owner, table name, create time,…

DB2 RazorSQL Database Conversion Database Conversion is used to change the database in other format. For example: You can change DB2 database…

DB2 RazorSQL Table Relationship Table relationship shows the relationship between columns and table. Next TopicDB2 Search

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,…