Mahmoud ElMansy: knowledge meant to be free

How To Get Column Name Only Without Data In SQL Server

In my daily work I always needs to know Table Structure or Column Names .
I usually use “sp_help TableName” To Get alot of information about table.
now i will introduce another Way to do That.

SET FMTONLY off
SELECT * FROM TABLE
-- This In The Top of your Query Will Get Only Column Name

Or You Can Use

sp_help TableName