Batch extract of SQL Server DDL -

since can point , click in ssms obtain ddl, there must assembly or dll of sort called gui. have familiarity how tap that?

the drive comes our need capture ddl part of jobs. of our batches need data 1 table or 1 index, others use entire database. getting detail needed critical. detail might used part of procedure or placed file.

i know there various solutions problem of batch/automated retrieval of sql server ddl (versions 2000-2014) on web. none directly supported microsoft, , need, considerable weakness.

of items on web, use scripts , system views/tables build ddl. admire work went these, such things may have problematic support , can break sql server version sql server version. also, number of vendors have tools, , there @ least 1 open source project (opendiff) ventures area. vendor tools won't fit batch streams. , third party tools require installation on client systems, sensitive area, , have licensing requirements. third party tool, of course, introduces various types of vendor dependencies.

there 1 item have found, smoscript, uses smos (with familiar). perhaps doing similar want, though limited notes on project imply not allow detail needed such single index. management viewpoint, introduces dependency on project , single author.

that assembly used ssms, whatever is, must kept date ms. if calling possible (though sure foolish hope simple), weakness of third party dependency eliminated. don't need web links scripts , third party tools have (yet thought), if can point me toward ssms using, might great help. in meantime, worth, i'll researching smos.