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

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

Re: what query can I run to tell me if a datetime column is ALREADY

Greg Fenton

2005-05-24, 1:23 pm

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

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

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Sponsored Links