4 Replies Latest reply: Aug 22, 2013 11:16 PM by SeshuNaresh RSS

    Retrieving the column schema

    SeshuNaresh

      Hi,

       

      I am unable to retrieve the column schema when i pass construct the query as

       

      "select * from(select name, age, rollno from student) a"

       

      I have used OracleDataReader's GetSchemaTable() methos with the CommandBehavior.KeyInfo as the parameter.

       

      I would like to read the primary key, isaliased and all the other properties?

       

       

       

      Thanks,

      naresh.