Gather Metadata For Each Column of SQL Table

Often when working with a new data set I'll run these queries to learn more about each column of data.

https://gist.github.com/aaronhoffman/eb30805ee2f5cafc64152dd1def800bd

For example, you can run a single query to union together aggregate data on each numeric column. Result looks something like this:



Hope this helps,
Aaron

Comments

Popular posts from this blog

Search iPhone Text Messages with SQLite SQL Query

How to Turn Off Microsoft Arc Touch Mouse Scroll Sound Vibration

Use Azure Functions to Execute a SQL Azure Stored Procedure on a Timer