how to retrieve primary key of a database ?
Visual Basic
1
Posts
1
Posters
0
Views
1
Watching
-
i have a oledb connection to a database which contains 5 tables. i had given the option to user to select any table. they will be dispalyed in a list. i have another listbox in which i want to bind the primary values of the table the user had selected. i want to do it in run time. my problem is that i dont know which column in the table are primary keys. "so is there any method through which i can know which column in a given table is primary key, which is foreign key" basically i want to retrieve the constraint and schema a code will be more helpful thanks......