Sunday, 15 June 2014

sql server - How to get the "Generate Script" of a DB by T-SQL -



sql server - How to get the "Generate Script" of a DB by T-SQL -

i know how using sql management generate script create whole db in sql.

i need same script using t-sql.

anybody know how this?

if i'm not mistaken function of sql ide. replicate you'd have lot of introspection yourself. perhaps have utilize 3rd party tool?

to introspection need tables , views in information_schema , sys schemas determine capabilities of every object , script them yourself.

there help stored procedures sp_helptext may able utilise create job easier.

sql sql-server tsql

No comments:

Post a Comment