You Can Create View in SQL by witting Query.
You Can Use SCHEMABINDING in View to hide definition of View.
By SCHEMABINDING on View you Cannot Use
-Union or Union All in View
-Distinct in View
-Sub Query and Self-Join in View
-Complex Aggregate Functions in View.
