How can I get a dump of all tables DDL?

Question

Rajanikant Hawaldar · Answer

You could try --schema-only (or --section=pre-data), possibly combined with -t 'schema1.*' ... -t 'schemaN.*' options of pg_dump. But these will give your not only tables, but also other stuff (like views, materialized views, foreign tables, and sequences). If you don't want these, you could try to experiment with pg_restore options (like -l / -L) and grep.

Pankaj Patel · Answer

Hi Dhawan, You can " get a dump of all tables DDL " using the mysqldump command line utility: mysqldump -d -u -p -h The -d option means "without data". For more detail you can refer below article: How to generate DDL for all tables in a database https://stackoverflow.com/questions/6597890/how-to-generate-ddl-for-all-tables-in-a-database-in-mysql/6597966 Hope, this will help you!

Rijwan Ansari · Answer

Hi, You can do with below mysql command mysqldump -d -u -p password > -h The -d option means "without data"

Riddhi Valecha · Answer

Hi, See this link and try to do this stored procedure - https://stackoverflow.com/questions/41557619/generate-ddl-script-from-sql-server-database https://stackoverflow.com/questions/30791482/sql-server-management-studio-2012-export-all-tables-of-database-as-csv

Vinitha T · Answer

mysqldump command line tool is used to dump all tables in databases managed by SQL and migrats the data to another server. To dump the table structure for all tables in database: mysqldump -d -u username -ppassword mydatabase > mydatabase_dump.sql -d -> not to include data in the dump -u -> username -p -> password mydatabase_dump.sql -> dumping the structure to a file. There should be no space between -p and password To dump a single table from your database. mysqldump --no-data -u username -ppassword mydatabase tablename --no-data can be used instead of -d To dump a multiple table from your database. mysqldump -d -u username -ppassword mydatabase tablename1 tablename2 tablename3 To create same table in another database: mysql -u username -ppassword newdatabase

How can I get a dump of all tables DDL?

Answers (5)