sql server query - get database tables schema and relations

Question

Is there a possibility to get the full database schema including table columns, indexex, views, relations, etc, with sql queries?

• get a list of all views from the database
• get a list of all users from the database
• get a list of all stored procedures from the database
• get a list of all functions from the database

• get a list of all tables from database and foreach table get:

  • get a list of all indexes
  • get a list of all keys (PK, FK)
  • get a list of all constraints
  • get a list of all indexes

  • get a list of all columns and foreach column get:

    • Name
    • PK / FK
    • Type (nvarchar, int, ..etc)
    • Not Null

Answer 1

As @lad2025 comments - yes, this is possible by querying the sys. schema. Technet article and tutorial available.