Get a Database Table properties programmatically
This program displays you a table properties such as its column names, types, and column properties. I have used a database mcTest.mdb which has a table called 'Developer'. You can download this attached database and change the path of the database according to your location.
The text of this article is not in this database — only its details are. The old site it was published on is gone, but the Internet Archive kept a copy: Get a Database Table properties programmatically
3 Comments
Join the conversation! Your thoughts help the community grow.
Sign in to leave a comment
It is the same account you read, post and publish with — and you will come straight back to this page.
sri kPosted Feb 26, 2008, 10:56 PM
Hi Mahesh Can you please advise how to get a column's max defined size i tried to use listBox1.Items.Add(dc.MaxLength) but it returns -1 Thanks Sri
PetePosted Aug 22, 2006, 11:52 AM
Hi Mahesh, When I run your code, for each column: the IsUnique values are always = False the auto-increment values are always = False and the allow-null values are always = True These are not accurate. What could wrong ? Thanks in Advance Pete