As a DBA we have to maintain our all databases Dictionaries, Here is a Script , from which we can generate a full view of Tables structure details. SELECT a.Name [Table Name], b.name [Column Name…