| As all of us know sql create MetaData for datatype objects and for contrainst . We can us this directly to understand this we use catalog view. Below Image is hierarchical structure of Catalog View . On top sys.objects is there which contains all schema scoped objects. Next all contains all the columns which relates to object.
| | |