Get all database names, table names, field names

-- 获取所有数据库名 select name from master..sysdatabases where name = ‘Fly‘-- 获取所有表名 select name from Fly..sysobjects where xtype=‘U‘ order by name --获取字段名SELECT COLUMN_NAME,DATA_TYPE FROM Fly.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME= ‘A‘DECLARE @DataBaseName nvarchar(100) ,@TableName nvarchar(100) ,@exec_Sql varchar(100)set @DataBaseName = ‘Fly‘set @TableName = ‘A‘set @exec_Sql = ‘SELECT COLUMN_NAME,DATA_TYPE FROM ‘ + @DataBaseName + ‘.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME= ‘ + ‘‘‘‘ + @TableName +‘‘‘‘exec(@exec_Sql)

Get all database names, table names, field names