摘要： 一、获取表的基本信息SELECT [TableName] = [Tables].name , [TableOwner] = [Schemas].name , [TableCreateDate] = [Tables].create_date , [TableModifyDate] = [Tables].modify_dateFROM sys.tables AS [Tables] INNER JOIN sys.schemas AS [Schemas] ON [Tables].schema_id = [Schemas].schema_id... 阅读全文