Shulou(Shulou.com)06/01 Report--

-- get all database names select name from master..sysdatabases where name = 'Fly'-- get all table names select name from Fly..sysobjects where xtype='U' order by name-- get field names SELECT COLUMN_NAME DATA_TYPE FROM Fly.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME= 'DataBaseName nvarchar select name from sysobjects where xtype='V'-all triggers select name from sysobjects where xtype='TR'-all stored procedures select name from sysobjects where xtype='P'-all views select name from sysobjects where xtype='V'-all tables select name from sysobjects where xtype='U'DECLARE @ DataBaseName nvarchar @ exec_Sql varchar 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)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.