Stage 8: Generate and review DDL
Knobit of Data modelling · K-852 · Knowledge
Explains SQL dialect differences
What it means
Types, identifier limits, reserved words, indexes and constraint enforcement differ by engine.
How it is assessed
Predicts how sample DDL renders and behaves on each engine
Builds on
- None
Needed by
- Recognises a check expression unable to runK-717 · Skill
- Recognises a configured dialect left unregeneratedK-806 · Skill
- Recognises a CHECK constraint parsed and ignoredK-808 · Skill
- Recognises an expression running on one engine onlyK-809 · Skill
- Recognises a truncated identifier taken as the real nameK-810 · Skill
- Recognises a reserved word used as an identifierK-811 · Skill
- Recognises a type meaning something else on another engineK-812 · Skill
- Recognises an index the target engine cannot create or runK-813 · Skill