public static string[] getTables(Connection conn, string dbName)
{
ArrayList tbls = new ArrayList();
SqlConnection sqlconn = new SqlConnection(conn.connectionString());
sqlconn.Open();
SqlCommand cmd = new SqlCommand(dbName + ".dbo.sp_tables", sqlconn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
if (
Convert.ToString(rdr["TABLE_TYPE"]) == "TABLE" &&
Convert.ToString(rdr["TABLE_OWNER"]) != "sys"
) tbls.Add(rdr["TABLE_NAME"]);
}
rdr.Close();
return tbls.ToArray(typeof(string)) as string[];
}