How do I get all the column information and indexes for a table in Access? (. net) __.net

The Access database is different from Oracle and SQL Server, and the system table does not provide information such as column information and indexes for the table, so taking this information is not a simple SQL statement that can be done, check it out, and use ADOX to complete these functions (in, net can also refer to ADOX), However, OleDbConnection provides a good way to do this in. net
To take column information:
DataTable mydbschemaguid_col= Conn. GetOleDbSchemaTable (Oledbschemaguid.columns,new object[]{null,null,this. TableName});
To fetch a column index:
DataTable mydbschemaguid= Conn. GetOleDbSchemaTable (Oledbschemaguid.indexes,new object[]{null,null,null});

For specific use, you can check. NET Help:

The above is purely a trigger.