>I know it's old but I see you didn't get a response. See if this works for you:
>
Select column_name, column_default
> From information_schema.columns
> Where table_name="mytable"
>I found this through a message reference by Sergey :) HTH
Yes, a year and a half is old! :)
I finally did find the solution, but thanks anyway! Funny thing is that haven't had an occasion to use that solution since! :)
Sylvain Demers