TIL: How to Show Column Types like MySQL's "Show Columns" statement

For all those MySQL devs who miss the simplicity of SHOW CREATE TABLE myTable or SHOW COLUMNS FROM myTable, here's the snippet you are looking for.

SELECT COLUMN_NAME,DATA_TYPE,CHARACTER_MAXIMUM_LENGTH,COLUMN_DEFAULT
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'myTable'
ORDER BY COLUMN_NAME;

(After I wrote all that...) nevermind, use sp_columns command, it is a lot more useful and easier to remember.

EXEC sp_columns myTable