獲取最近一次更改時間
use [test]
go
select * from sys.tables where name='TaskNew'

image.png
use [test]
go
select top 1 modify_date from sys.tables where name='TaskNew'

image.png
說明:test:數(shù)據(jù)庫名
TaskNew:表名
use [test]
go
select * from sys.tables where name='TaskNew'
use [test]
go
select top 1 modify_date from sys.tables where name='TaskNew'
說明:test:數(shù)據(jù)庫名
TaskNew:表名