in the sysobjects one column is there with name crdate, but this is
not updated properly. If anyone is having any info please help me.

Balu Dhaker
Centre for Railway Information System

Can you expand on "not updated properly". The column is set when the
object is created and it does not change. Are you indicating that the
value is not set correctly at the time that the object is created?

-chris


Balu wrote:

sysobjects is a compatability view only. It's job is to
just be defined so to ease the migration of T/SQL scripts
ported from other servers to SQL Anywhere. As such
it provides rows and columns that match the most generic
requirements only but stubs out all of the rest of the columns.

For crdate, that column is simply defined as

cast(null as date)

for most object types since historically that information
was not captured.


"Balu" <baludhaker (AT) gmail (DOT) com> wrote