Check constraints
Default objects
Computed columns
Views
User-defined functions
User-defined aggregates
Sub-queries
Common table expressions
Derived tables
Top
Over
Output
On
Where
Group By
Having
Order By
Compute
Compute By