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