MS SQL SERVER 获取当前数据库文件等信息,适用于多个版本: 复制代码 代码如下:SELECT dbf.file_id AS FileID , dbf.name AS [FileName], s.filename AS FileLocation , CAST(dbf.size/128.0 AS DECIMAL(19,2)) AS FileSizeMB , CAST(CAST(FILEPRO..
复制代码 代码如下: SELECT Name FROM Master..SysDatabases ORDER BY Name --获得所有数据库 SELECT Name FROM [数据库名]..SysObjects Where XType='U' ORDER BY Name --获得数据库下的所有表 select name from syscolumns where id=object_id(N'..