Re: [GENERAL] table updated status

2007-02-06 Thread Richard Huxton
finecur wrote: Hi, Can I list tables and the time they were last update (adding columns, drop columns) using sql, something like the "ls -l" command under unix? No. There's no automatic timestamping. You could add your own triggers if you wanted though. Can I compare the table definitions

[GENERAL] table updated status

2007-02-05 Thread finecur
Hi, Can I list tables and the time they were last update (adding columns, drop columns) using sql, something like the "ls -l" command under unix? Can I compare the table definitions (tables, fields, but not data) of two database using sql, something like the "diff file1, file2" command under unix