var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: extract DDL in SQL server 2005
My requirement is to extract DDL for all objects (Functions, SP's, Tables, Indexes etc.) from the Database. Is their a way to do this in SQL server 2005?
What i'm looking for a equivalent of DBMS_METADATA.GET_DDL() in oracle. I had a look at the SP_HELPTEXT() but i think that is needed to extract DDL for a particular SP/function.
In theory, theory and practice are identical. In practice, theory and practice are unrelated.
Hi There, There a handy and simple command line tool to do this, the DDL Extractor. You can find it at www.antipodeansoftware.com