Get the exact data types from a sql table

[Ista]

Is there a way I can extract the extact data type strings but sql via ADO.NET. I need to know the exact name of the data type from sql. I tried creating a data table and filling it, then examining the columns. But, only gives me a .net data type. For instance, smalldatetime is converted to DateTime. I need to know what it is before the conversion. thanks nick

-------------------------------------------------------- 1 line of code equals many bugs. So don't write any!! My mad coder blog

[mikone]

you could try to perform a query which shows you the tables structure ( MySQL: desc Tablename; - Firebird: show table Tablename; ) and parse the result in your programm. That way you would get the name of the datatypes used by your database.