Database unit tests can be created for
All DDL statements
All DML statements
SPs, functions and triggers
DDL & DML