By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,099 Members | 2,156 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,099 IT Pros & Developers. It's quick & easy.

SQL statement to report a tables's attribute types

P: n/a
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

Oct 11 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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
Oct 11 '07 #2

P: n/a
Hi,

Thanks for the help.

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

Is there a way?

Oct 15 '07 #3

P: n/a
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
Oct 15 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.