Java – how to export the DDL of all objects (such as tables, indexes, etc.) in Sybase IQ / Sybase ASE without using any tools?
I've created a sample program, and I want to use get_ The DDL method obtains the DDL of all objects, such as table, trigger, etc It worked when I tried to trace queries in Oracle
SELECT DBMS_MetaDATA.GET_DDL('TABLE',TABLE_NAME) FROM USER_TABLES; SELECT DBMS_MetaDATA.GET_DDL('TRIGGER',TRIGGER_NAME) FROM USER_TRIGGERS; SELECT DBMS_MetaDATA.GET_DDL('VIEW',VIEW_NAME) FROM USER_VIEWS; SELECT DBMS_MetaDATA.GET_DDL('FUNCTION',OBJECT_NAME) FROM USER_PROCEDURES WHERE OBJECT_TYPE = 'FUNCTION'; SELECT DBMS_MetaDATA.GET_DDL('PROCEDURE',OBJECT_NAME) FROM USER_PROCEDURES WHERE OBJECT_TYPE = 'PROCEDURE'; SELECT DBMS_MetaDATA.GET_DDL('INDEX',INDEX_NAME) FROM USER_INDEXES ;
But it doesn't work when I try to create the same sample for SYBASE to get the DDL or script of all objects Because get is not supported in Sybase database_ ddl. Anyone can help me know if Sybase IQ 15 supports get_ DDL method, or is there any other method / method or query to create DDL / script for all objects
I want to post it on the sap forum, but all websites are unavailable. Anyone can suggest me to link and post my questions
Thank you in advance!!
Solution
From sys Extract the DDL of triggers, stored procedures and views from syssource Unfortunately, IQ does not store DDL for other objects