| DB2 | MySql | Oracle | SQL Server | |
|---|---|---|---|---|
| Create Tablespace | CREATE TABLESPACE | |||
| Create Schema | CREATE USER for schema | |||
| Create User | CREATE USER | |||
| Create Role | CREATE ROLE | |||
| Create Sequence | CREATE SEQUENCE | |||
| Create Table | CREATE TABLE |
| Data Type | DB2 | MySql | Oracle | SQL Server |
|---|---|---|---|---|
| Date and time (date + hh:mm:ss) | ||||
| Timestamp (date + hh:mm:ss.ff...) | TIMESTAMP |
| Task | DB2 | MySql | Oracle | SQL Server |
|---|---|---|---|---|
| Backups | ||||
| Recovery | RMAN |