DB2 RazorSQL Show Info Show info is used to retrieve all information of the table. i.e. table owner, table name, create time,…
DB 2 Tutorial
-
-
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,…