Search This Blog

Sunday 5 March 2017

Get table creation date in Oracle / SQL

--Oracle
 SELECT Object_Name "Table_Name", created "Create_Date"
    FROM dba_objects
   WHERE object_name = 'TABLE_NAME'
     AND owner = 'TABLE_OWNER'
     AND object_type = 'TABLE';

--SQL
SELECT NAME 'Table_Name'Create_Date modify_date
FROM   sys.tables
WHERE  NAME = 'TABLE_NAME'

No comments:

Post a Comment