command to find table description

[hok1man]

Hi guys,

I'm newb in sybase, I'm using SQL server and oracle.
so,

quick question about subject thread,
in oracle command we can do.
desc [table name]

what about in sybase?

and what the default format if we want to put date input?
in the column I saw the format like
20081223

but if I put like this

update table1
set dt_tran = '20081223'
where dt_tran = NULL

that above code doesn't work.

Can you guys shed some light please?

 

[thekl0wn]

Try replacing the "=" with "IS"...

WHERE dt_tran IS NULL