Export as SQL 
Author Message
 Export as SQL
Hi, im a MS Sql user, im changing now to DB2 (trying out the personal
edition), how, do i export a table as sql, i mean how do i generate the SQL
to build a table like the one i have after it has been created/altered, i
know there is a option (show sql) but i dont wanto to use it right then, i
was thinking in something like i build, alter a table and then generate the
sql, thanks a lot in advance

jorge



Fri, 11 Oct 2002 03:00:00 GMT
 Export as SQL


Quote:
> Hi, im a MS Sql user, im changing now to DB2 (trying out the personal
> edition), how, do i export a table as sql, i mean how do i generate the
SQL
> to build a table like the one i have after it has been created/altered, i
> know there is a option (show sql) but i dont wanto to use it right then, i
> was thinking in something like i build, alter a table and then generate
the
> sql, thanks a lot in advance

You have two choices.
First, there is the "Generate DDL" context menu option in Control Center.
Second, you can use db2look.exe directly.


Fri, 11 Oct 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Exporting from SQL 2k to SQL 7

2. sql 2000 export to sql 7.0

3. SQL Server 2000 - Export to SQL Server 7.0????

4. SQL Server 7 EE export to SQL script

5. Question in regards to .CSV file when exporting from SQL to Access Database

6. BCP Export on SQL Sercer 6.5

7. Newbie Q: Export from SQL Server

8. Text file export in SQL Server 2000 DTS - field limits

9. multi instances of import/export of sql server

10. Error Message When Exporting to Sql Server 7 Over Internet

11. AS/400 export to SQL Server


 
Powered by phpBB® Forum Software