Check the OpenSchema method of the ADO Connection object.
>Dear the experts..
>How to get table's keys informations from Ms. SQL Server database via VB6's code? thanks
>
>Winan
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com