Can I generate CREATE TABLE from a visio diagram?

I have a database dia开发者_StackOverflow中文版gram done up in Visio 2003 Professional.

Is there any way to re-engineer the database from the diagram?

You need Visio for Enterprise Architects, which was previously supplied with some of the higher editions of Visual Studio. It (and only it) had the ability to generated database scripts from a Visio diagram.

To my knowledge, older versions of Visio could do it in the standard version. Visio 2000 (yes, that old) had very solid forward and reverse engineering functionality. Maybe you can get hold of that version (current versions should still be able to save in that format).