A Gentle Introduction to

SQL

USERS

How to create users, give them access, get at other peoples tables. How to find processes and kill them.


Change the default schema/database.
In many engines several independant databases may exist. Often each user has his or her own database. This allows different users to use the same names for tables.
db2 variations:
The "connect to" syntax works in the command line processor (clp). This connects you to a database. There are schema within the each database.
instance contains databases
databases contain schema
schema contain tables and views...


access
db2
mysql
oracle
postgres
sqlserver