--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