我该如何在Teradata中查找表的最后更改日期？

Question

我在Teradata中有一张表，怀疑被更改了。是否有一个快速的SQL命令可以像SQL Server那样获取这些信息?

- Keng

Answer 1

这是它

SELECT TABLENAME, LASTALTERTIMESTAMP 
FROM DBC.TABLES
WHERE DATABASENAME = 'My DB Name' -- OPTIONAL
ORDER BY LASTALTERTIMESTAMP DESC

- Keng

Answer 2

SELECT TableName, LastAlterTimeStamp 
FROM DBC.TABLES
WHERE DATABASENAME = 'Your DB Name' AND tablename='Your Table Name'
ORDER BY LASTALTERTIMESTAMP DESC

- Ranjeet Yadav