CODEWITHSUNDEEP
sqlsap-ase
antosnowin
antosnowin

Reputation: 221

Extract SP and DDL Scripts in sybase Server

How do I extract DDL, Stored Procedures (SP) and other database scripts from Sybase ASE.

Upvotes: 1

Views: 6876

Answers (2)

Mike Gardner
Mike Gardner

Reputation: 6651

Look into the ddlgen utility included with sybase, ususally found in the Sybase Central directory, or the $SYBASE/ASEP/bin. This should be able to generate scripts to create all of the database objects including user-defined datatypes (UDD), indexes, stored procedures, etc.

Upvotes: 1

Iswanto San
Iswanto San

Reputation: 18569

You can use sp_helptext to show the DDL.

Upvotes: 1

Related Questions