as Enterprise manager can find your mistakes, and writing a SQL Script by hand more than likely won't until you go to run it. Typos and things like that.
It can be done by hand, or even Visual BASIC 6.0 has some SQL Server tools in it. Which is why MSDE 2000 has a license for use with VIsual Studio 6.0 because of the SQL Tools in it.
Still maybe FIrebird has an IDE Interface for it somewhere? I haven't found one yet, I downloaded the Firebird database, but I hadn't had time to figure it out yet without some GUI to guide me. I need error checking to work out my typos.