22-25 April 2026
Video unavailable
SQLBits 2022

Safeguard your tables using views and constraints

Safeguard your tables using views and views
Prevent data anomalies using contraints. Why are primary keys, defaults, checks, unqiues, and foreign keys required? Use views to hide and secure your underlying tables using projection, filtering, schemabinding, check option, encryption, and indexes.