SQL Server scripting

[Guest]

hi

I wanted to know, is it possible to write .net code to generate
database script?

For example, I will give table name, .net code should generate
script from the database.

thanks
kalyan

 

[Peter Rilling]

Sure. All you need to go is get the metadata what is in the sysX tables and
then generate your scripts accordingly.

 

[Guest]

Sysobjects and syscolumns are key tables. But I guess there's not automated
tool available in .net.