private IEnumerable<string> GetColumnNames(string conStr, string tableName)
{
var result = new List<string>();
using (var sqlCon = new SqlConnection(conStr))
{
sqlCon.Open();
var sqlCmd = sqlCon.CreateCommand();
sqlCmd.CommandText = "select * from " + tableName + " where 1=0"; // No data wanted, only schema
sqlCmd.CommandType = CommandType.Text;
var sqlDR = sqlCmd.ExecuteReader();
var dataTable = sqlDR.GetSchemaTable();
foreach (DataRow row in dataTable.Rows) result.Add(row.Field<string>("ColumnName"));
}
return result;
}
--数据库中的表名称(这样就可以查询到你说的那四个表)
SELECT name FROM sys.objects
WHERE [type]='U'
--通过表名称查询列名(tab2就好比你的表名称)
SELECT name FROM sys.syscolumns
WHERE id=OBJECT_ID('tab2')