N nitesh Oct 28, 2009 #1 i want to get all constraints name, its type which was defined in my database. is there any query to find out .
i want to get all constraints name, its type which was defined in my database. is there any query to find out .
A Allen Browne Oct 29, 2009 #2 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
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
