When you have a SQL table with multiple fields and if you want to view the fields in alphabetical order, use this script.
SELECT
COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, IS_NULLABLE, ORDINAL_POSITION
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = <Your Table Name inside quotes>
ORDER BY COLUMN_NAME ASC
