SQL statement to report a tables's attribute types

[leegold58]

Is there an SQL statement that will search a table's attribute types
and report if there are any text, Blob, or memo fields?

Are there any other Access data types that can hold text information?

Thanks

[Allen Browne]

To answer your specific questions:

1. There isn't a simple way to use a SQL statement to get the column info.

2. Hyperlink might be considered as text. (Internally in Access, it's
actually a memo with an attribute set.)

Here's an example of how to list the fields in a table using code, along
with their properties (including description):
http://allenbrowne.com/func-06.html

You can also use ADOX to list the columns in a table:
http://allenbrowne.com/func-ADOX.html#ShowAllTables

And here's a reference of the various field type names and constants used by
the various libraries:
http://allenbrowne.com/ser-49.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"leegold58" <go******@worldpost.comwrote in message
news:11**********************@y42g2000hsy.googlegr oups.com...

Is there an SQL statement that will search a table's attribute types
and report if there are any text, Blob, or memo fields?

Are there any other Access data types that can hold text information?

Thanks

[leegold58]

Hi,

Thanks for the help.

But I was looking for SQL to get the info. purely SQL not VB.

Is there a way?

[RoyVidar]

leegold58 wrote:

But I was looking for SQL to get the info. purely SQL not VB.

Is there a way?

As far as I know, not with Jet backend (mdb-file).

--
Roy-Vidar