is there any standard way to.. Data Types

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
Sat Dec 20 02:45:40 CST 2003

You might take a look at
OleDbConnection.GetOleDbSchemaTable Method

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

"Daniel Bello Urizarri" <dburizarri@hotmail.com> wrote in message
news:u$HLRtpxDHA.2308@TK2MSFTNGP11.phx.gbl...
> 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
>
>

Daniel
Mon Dec 22 13:07:06 CST 2003

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" <miha at rthand com> wrote in message
news:OXrrmWtxDHA.2508@TK2MSFTNGP12.phx.gbl...
> You might take a look at
> OleDbConnection.GetOleDbSchemaTable Method
>
> --
> Miha Markic - RightHand .NET consulting & development
> miha at rthand com
> www.rhand.com
>
> "Daniel Bello Urizarri" <dburizarri@hotmail.com> wrote in message
> news:u$HLRtpxDHA.2308@TK2MSFTNGP11.phx.gbl...
> > 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
Mon Dec 22 13:33:05 CST 2003

Hi Daniel,

Unfortunatelly not.

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

"Daniel Bello Urizarri" <dburizarri@hotmail.com> wrote in message
news:ea4lZ9LyDHA.4060@TK2MSFTNGP11.phx.gbl...
> 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" <miha at rthand com> wrote in message
> news:OXrrmWtxDHA.2508@TK2MSFTNGP12.phx.gbl...
> > You might take a look at
> > OleDbConnection.GetOleDbSchemaTable Method
> >
> > --
> > Miha Markic - RightHand .NET consulting & development
> > miha at rthand com
> > www.rhand.com
> >
> > "Daniel Bello Urizarri" <dburizarri@hotmail.com> wrote in message
> > news:u$HLRtpxDHA.2308@TK2MSFTNGP11.phx.gbl...
> > > 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
> > >
> > >
> >
> >
>
>