How to retrieve SQL script for table creation from Informix

If you need to drop a table in informix and create it again, you require the script which was initially used to create that table. To get the SQL script, we use dbschema command. Most frequently, the command is used in the following format.

dbschema -d <database> -t <tablename> -ss <file_name>
                                                                             |__ To Generate Server Specific Information

An example is given below:

The above command will take the backup of all the tables in the database smdb and store it in the file ‘smdb_20100624.sql’.

Adnan Khurshid

Adnan Khurshid, the author of this article, has been working in a telecommunication sector since 2007. He has worked there as a VAS (Value Added Services) engineer and has excelled remarkably in the field. Working in this field has been his passion and he has always made efforts to keep himself up to date. Find more about him on LinkedIn

More Posts

Tags: dbschema, sql script for tables