Need to export SQL for creating table(s) from Enterprise Architect

sql enterprise-architect
Askar Ibragimov picture Askar Ibragimov · Aug 9, 2013 · Viewed 11.1k times · Source

I need to create SQL statements from Enterprise architect v.9 table description, since I need "CREATE TABLE" to be placed in a text file.

Please advice me where to look in EA interface!

Answer

Pedro Dusso picture Pedro Dusso · Aug 23, 2013

In the diagram where your tables are designed, select all of them and right click in one of the tables. Look for SQL Code Generation and choose one of the options: single DDL script or not.

The difference is that in the single script all create table statements will be generated in only one file (which is usually better!)

Related questions

How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More
How do I perform an IF...THEN in an SQL SELECT?

How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product

Read More
How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More