Return Database Schema for Table Using Power Query

Point this query to your database table and return all columns and schema meta data using Power Query in Excel

me@jaykilleen.com wrote this 12 months ago and it was last updated 12 months ago.


← Back to the Posts

let
  Source = Odbc.Query("dsn=insert-windows-odbc-data-source-connection-name-here", 
"
SELECT 
  *
FROM 
  INFORMATION_SCHEMA.COLUMNS 
WHERE
  TABLE_SCHEMA = 'insert-table-name-here'

"
  )
in
  Source

Similar