is there any standard way to.. Data Types

[Daniel Bello Urizarri]

Hi:

Is there any standard way to ask for the data types on a data base:
Something like:

SELECT * FROM INFORMATION_SCHEMA.DATA_TYPES

to get something like: char, int, image, varchar, money....

So later I can do something like:

CREATE TABLE NewTable (NewField
_Field_Type_selected_by_user_from_a_combo_box_)

Thanks

 

[Miha Markic]

You might take a look at
OleDbConnection.GetOleDbSchemaTable Method

 

[Daniel Bello Urizarri]

Hi:

GetOleDbSchemaTable is ok with OleDb, but suppose im using an unknown
database through an unknown ADO.NET driver. I want to have an standard
alternative for that case. Some kind of INFORMATION_SCHEMA views or some
other standar way of asking for information. Is there any?

Thanks.

 

[Miha Markic]

Hi Daniel,

Unfortunatelly not.