> Create Database Objects – CREATE/ALTER/DROP TABLE/COLUMN – Data Types (XML, DATETIME, SPATIAL, VARCHAR) – Constraints (Primary Key, Foreign Key, Unique, Check, Default) – Calculated Column – Views – Indexed Views (SCHEMABINDING, COUNT_BIG(*), CLUSTERED INDEX) – Stored Procedures, [link]. – DML Triggers (INSERTED, UPDATED, UPDATE function) vs CHECK Constraint – TRIGGER for VIEWS (INSTEAD OF) …Continue reading