I needed the definitions (data type, length and nullability) of columns in some SQL Server views so I can replicate the structure as table in test system.
Turns out it’s super easy to get this information.
Just execute this statement:
EXEC SP_HELP {view_name};