Get the field type for each column in a table


PHOTO EMBED

Thu Sep 17 2020 20:48:35 GMT+0000 (UTC)

Saved by @cbarsis #sql

SELECT column_name as 'Column Name', data_type as 'Data Type'
FROM information_schema.columns
WHERE table_name = 'hrStaff' 
content_copyCOPY