HOW TO GET ALL CONSTRAINT NAME ,TYPE,TABLENAME WITH QUERY

[nitesh]

i want to get all constraints name, its type which was defined in my
database. is there any query to find out .

 

[Allen Browne]

For JET tables (native tables in an Access database), so of the field info
is available on by using DAO. Here's an example of how to code it:
http://allenbrowne.com/func-06.html

If you don't need all the properties, you can use ADO:
http://allenbrowne.com/func-ADO.html#ShowSchema
or ADOX:
http://allenbrowne.com/func-ADOX.html#ShowAllTables