奇葩需求查询语句

查询数据库所有表创建时间

select name,create_date,modify_date from sys.objects

知道列名找表

SELECT OBJECT_NAME(id) AS ‘表名’,name AS ‘列名’ FROM syscolumns WHERE name =’guid’

–如果是sql 2000的话

SELECT OBJECT_NAME(id) AS ‘表名’,name AS ‘列名’ FROM syscolumns WHERE name =’model’