ALTER TABLE
) to transit the source database schema state to each of the target database schema.Object | MySQL | PostgreSQL | TiDB | Oracle | SQL Server |
---|---|---|---|---|---|
Schema | — | ✅ | — | ✅ | ✅ |
Table | ✅ | ✅ | ✅ | ✅ | ✅ |
Column | ✅ | ✅ | ✅ | ✅ | ✅ |
Primary Key | ✅ | ✅ | ✅ | ✅ | ✅ |
Foreign Key | ✅ | ✅ | ✅ | ✅ | ✅ |
Index | ✅ Regular, Unique, Fulltext, Spatial | ✅ Including Expression & Partial | ✅ | ✅ Regular, Unique, Bitmap, Function-based | ✅ Clustered, Non-clustered |
Check Constraint | ✅ (8.0+) | ✅ | ❌ (metadata sync limitation) | ✅ | ✅ |
View | ✅ | ✅ | ✅ | ✅ | ✅ |
Materialized View | — | ✅ | — | ✅ | ❌ |
Generated/Computed Column | ✅ STORED/VIRTUAL | ✅ STORED | ✅ | ✅ Virtual | ✅ Computed |
Identity/Auto Column | ✅ AUTO_INCREMENT | ✅ SERIAL/IDENTITY | ✅ AUTO_RANDOM | ✅ IDENTITY (12c+) | ✅ IDENTITY |
Partitioning | ✅ KEY, HASH, RANGE, LIST | ✅ | ✅ | ✅ RANGE, LIST, HASH, COMPOSITE | ❌ |
Sequence | — | ✅ | — | ✅ | ✅ |
Trigger | ✅ | ✅ | — | ✅ | ✅ |
Function | ✅ | ✅ | — | ✅ | ✅ |
Procedure | ✅ | ✅ | — | ✅ | ✅ |
Package | — | — | — | ✅ | — |
Custom Type | — | ✅ Enum only | — | ✅ | ✅ |
Extension | — | ✅ | — | — | — |
Comments | ✅ | ✅ | ✅ | ✅ | ✅ |