Changing indexed to NO in Jet DB
Database
1
Posts
1
Posters
0
Views
1
Watching
-
Hi, I'm having problems finding out how to delete a field in a jet (Access) database via SQL code (using OleDbCommand in C# code). This field is set to Indexed=Yes (no dups). From my research, it looks like I have to change the Indexed to 'No' before deleting the field? I found this on the net, but if the field was created with MS Access app, I don't know the idxName to use in my SQL code. DROP INDEX idxName ON tblCustomers thanks for any help you can give, Ron