search

Home >Database >Mysql Tutorial >查询数据库最后修改时间与创建时间（表的修改时间)

查询数据库最后修改时间与创建时间（表的修改时间)

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-07 17:47:292527browse

查询数据库最后修改时间与创建时间（表的修改时间)

查询最后修改时间与创建时间（表的修改时间)

//查询数据库最后修改时间2005
select modify_date from sys.objects where object_id=object_id('table_name')

select modify_date from sys.objects where object_id=object_id('table_name')

//表最后修改时间
select * from sysobjects
//这样只能查出创建日期

select * from sys.databases

Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mssql日期函数[数据库中查询整数天或者整数月]Next article：mssql server 树形结构的存储与查询实例

Related articles

See more