The underpinning tests for this page don’t cover all known functional dependencies of the SQL standard yet. Just those listed below.
PRIMARY KEYs or UNIQUE constraintsThe known functional dependencies of SQL are specified in ISO/IEC 9075-2:2023 §4.26. The respective optional feature T301, “Functional dependencies” first appeared in the edition of 1999.
You can’t catch up on 20 years of SQL evolution in one day. Subscribe the newsletter via E-Mail, Bluesky or RSS to gradually catch up and to keep modern-sql.com on your radar.
Markus Winand provides insights into SQL and shows how different systems support it at modern-sql.com. Previously he made use-the-index-luke.com, which is still actively maintained. Markus can be hired as trainer, speaker and consultant via winand.at.
The essence of SQL tuning in 200 pages
Buy now!
(paperback and/or PDF)
Paperback also available at Amazon.com.
Markus offers SQL training and consulting for developers working at companies of all sizes.
Learn more »