I could like to see all data with columns name in my logfile.

 private static void ExecuteSQL()
    {

        string conn = "User ID=SYSDBA;Password=masterkey;Database=XX.18.137.XXX:C:/ER.TDB;DataSource==XX.18.137.XXX;Charset=NONE;";

        FbConnection myConnection = new FbConnection(conn);
         FbDataReader myReader = null;
         string sql = "SELECT * FROM RDB$RELATIONS";

        FbCommand myCommand = new FbCommand(sql, myConnection);
        try
        {
            myConnection.Open();
            myCommand.CommandTimeout = 0;
            myReader = myCommand.ExecuteReader();

            while (myReader.Read())
            {
              //  Log.WriteLog(myReader["rdb$relation_name"].ToString());

            }
            myConnection.Close();
        }
        catch (Exception e)
        {
            Log.WriteLog(e.ToString());
        } 
    }

Right now its only showing me the rdb$relation_name this column.

I want to check the different tables for which i dont have columns name.

Thanks in Advance !!

Related posts

Recent Viewed