查詢SQL Server中的表名

SqlConnection conn= new SqlConnection("server=.;uid=sa;pwd=123;database=08_09cgywdb;Connection TimeOut=2");

conn.Open();

SqlCommand comm=new SqlCommand("SELECT OBJECT_NAME (id) FROM sysobjects WHERE xtype = 'U' and name like 'tbl20%' ORDER BY Name", conn);

SqlDataReader sdr = comm.ExecuteReader();

while (sdr.Read())
{
  //MessageBox.Show(sdr.GetString(0));
 MessageBox.Show(sdr[0].ToString());

}

//comm = new SqlCommand("select * from sysobjects  where [type] = 'U'", conn);
//SqlDataReader sdr = comm.ExecuteReader();
 //while (sdr.Read())
 //{
 //    for (int index = 0; index < sdr.FieldCount; ++index)
//     {
//         MessageBox.Show(sdr[index].ToString()); //表的詳細資料
 //     }
//}

sdr.Close();
conn.Close();