SQL Anywhere database - what query can I run to tell me if a datetime column is ALREADY default timestamp

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

what query can I run to tell me if a datetime column is ALREADY default timestamp

Kumar

2005-05-24, 1:23 pm

Is there a query I can run to determine if a datetime field type is
defaulted to timestamp or not?

--
TIA,

-k-

Kumar

2005-05-24, 8:23 pm

Very much so. Thanks,
-k-

"Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> wrote in message
news:4293714e$1@foru
ms-1-dub...
> Does this query give some insight?
>
> SELECT t.table_name, c.column_name, c."default"
> FROM syscolumn c KEY JOIN systable t
> WHERE c."default" IS NOT NULL

Sponsored Links