How to: Retrieve database schema information using ADO.NET

Sometimes we need to know what is the internal structure of a database in addition to its data. This might turn very useful when the database structure is dynamic. This information is called Database Metadata or Database Schema.