SqlServer查看表信息（建立时间，更新时间）

SELECT [TableName] = [Tables].name ,
        [TableCreateDate] = [Tables].create_date ,
        [TableModifyDate] = [Tables].modify_date
FROM    sys.tables AS [Tables]
        INNER JOIN sys.schemas AS [Schemas] ON [Tables].schema_id = [Schemas].schema_id
ORDER BY TableCreateDate DESC