Personal tools
You are here: Home → DB2 → How To's → How to get and change the current schema
Navigation
Log in


Forgot your password?
 
Document Actions

How to get and change the current schema

Command to get and change the current schema you are logged in

Sometimes, if you want to know which schema you are using, you can issue the command:

$db2 values current schema

The output is the following:


$ db2 values current schema

1                                                                               
-------------------------------------------
DB2INST2                                                                        

  1 record(s) selected.


To change the current schema issue the following command:

db2 set schema <SchemaName>
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls