我在Teradata中有一张表,怀疑被更改了。是否有一个快速的SQL命令可以像SQL Server那样获取这些信息?
这是它
SELECT TABLENAME, LASTALTERTIMESTAMP
FROM DBC.TABLES
WHERE DATABASENAME = 'My DB Name' -- OPTIONAL
ORDER BY LASTALTERTIMESTAMP DESC
SELECT TableName, LastAlterTimeStamp
FROM DBC.TABLES
WHERE DATABASENAME = 'Your DB Name' AND tablename='Your Table Name'
ORDER BY LASTALTERTIMESTAMP DESC