You can view MS SQL server database schema details in a variety of ways.
Related Reference
MS SQL Server DB Structure view
MS SQL Server DB Details view