Hi,
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
NAME VARCHAR(250)
DECIMAL DECIMAL(22,2)
It is similar to desc command in oracle.The same way and format,i need sql.
Please help me on this.