I need sqlserver query to give output like DESC TABLE_NAME command in oracle.
I know sp_help 'table_name.but i want output like below,
COLUMN_NAME NULL TYPE
ID YES NUMERIC(38)
DATEFILED NO DATE
It is similar to desc command in oracle.The same way and format,i need sql.
Please help me on this.