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 over 1 year ago and it was last updated over 1 year 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