SQL SERVER – Total No of Columns in a Table for a given Database

One evening my friend Preethy came ask, “Can we find the how much columns are there in a table For a given database?”. I had given a script to her.

Total no of columns in a table for a given database

Query to find all sum of columns in a table of a given database.

Total no of columns for each tables of a given database.