DB2 RazorSQL CREATE The CREATE option facilitates you to create many things in DB2 database i.e. create table, create view, create index,…
DB 2 Tutorial
-
-
DB2 RazorSQL Search The Search option facilitates you to search for any column in the table. For example: You can search for…
-
DB2 Create Database CREATE DATABASE command is used to create a database in an instance. All databases are created with the default…
-
DB2 RazorSQL View A view is used to define an alternative way of representing the data stored in a table. A view…
-
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.…