DataSet dsTableNames = new DataSet();
SqlConnection connection = new SqlConnection(Properties.Settings.Default.connectionString);
SqlCommand command = new SqlCommand();
string commandtext = "SELECT sys.sysobjects.name " +
"FROM sys.sysobjects INNER JOIN " +
"sys.syscolumns ON sys.sysobjects.id = sys.syscolumns.id " +
"WHERE (sys.syscolumns.name = @Column)";
command.CommandText = commandtext;
command.Parameters.Add(new SqlParameter("@Column", columnName));
command.Connection = connection;
SqlDataAdapter adapter = new SqlDataAdapter(command);
adapter.Fill(dsTableNames, "tableNames");
zaterdag 3 oktober 2009
Get table names of all tables containing a given column
Abonneren op:
Reacties posten (Atom)
Geen opmerkingen:
Een reactie posten