How to extract a whole database schema using only ODBC access?
Following on from chat in "The Heap"...

Visio can reverse engineer a database. However, I assume thus needs to read metadata or system tables to get everything (keys, DRI, datatypes the works).

This old MSDN article may help "Migrating Btrieve Applications to MS SQL Server 7.0" too