Check Database Authority Use the following syntax to check the database authority which are granted to PUBLIC on the non-restrictive database: 1.…
what is db2
-
-
DB2 RazorSQL Create Index Create Index is used to create index for a table. An index is a set of pointers which…
-
DB2 RazorSQL Row Count Row Count is used to count the number of number of rows in the table. Let’s see the…
-
Connect to the Database Once the database is created, you have to connect or start database to make it in use. Syntax:…
-
DB2 RazorSQL CREATE The CREATE option facilitates you to create many things in DB2 database i.e. create table, create view, create index,…
-
DB2 RazorSQL Search The Search option facilitates you to search for any column in the table. For example: You can search for…
-
Create a Bufferpool If you want to create a new bufferpool for database server, you just need two parameters named “bufferpool name”…
-
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 Create Database CREATE DATABASE command is used to create a database in an instance. All databases are created with the default…