how to find latest table created from database.

[KIDYA]

Hi.. Can anybody tel me how to find latest table created from database and display first in combo box list.

[Noctris]

That depends on the database.. but most have a master db where you can query that type of information (Mysql, MS SQL) You should look at the vendors site how to query the master db/table and you should be there

Do Or Don't, there is no "try catch ex as exception end try"

[Mycroft Holmes]

Look into the system information/schema views in sql 2005+ and sysobject in earlier versions.

Never underestimate the power of human stupidity RAH

[J4amieC]

See my answer above, you have this whole database thing wrong- you dont create new tables for entities - you create new rows within a table. If you add a timestamp to every row, its pretty darn easy to find the most recently created row.

[Rajesh Anuhya]

if u r using oracle go through this SQL> desc dba_objects; Name -------------------------------- OWNER OBJECT_NAME SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE CREATED LAST_DDL_TIME TIMESTAMP STATUS TEMPORARY GENERATED SECONDARY dba_objects has every objects create datestamp.. i think this may help u

Rajesh B --> A Poor Workman Blames His Tools <--