db2 tutorial

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

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

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 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 Bufferpool You can drop a bufferpool by using “drop bufferpool” command. It is suggested to check if any tablespace is assigned…

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

DB2 RazorSQL View A view is used to define an alternative way of representing the data stored in a table. A view…

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