How to extract metadata for the entire database?
It’s quite simple, use isql with -x or -a options. Please be careful and test if it works. Some commercial administration tools like to play with system tables directly, and isql isn’t always able to understand their hacks
You can also extract DDL with FlameRobin Open the properties page for the database and select DDL option at the top.