Programmatically get the creation of a database table script in .NET.

Question

I need to get a CREATE TABLE script to recreate a specific table in a SQL Server (2000) database, programmatically (I use C #). Obviously, you can do this using Enterprise Manager, but I would like to automate it.

I played with SQLDMO, which offers a backup command, but I'm not sure if this will give an SQL CREATE TABLE script and seems to require creating a SQL Service device, and I would prefer to avoid modifying the database.

Answer 1

. sql script, INFORMATION_SCHEMA . , .

Answer 2

SMO . .: http://www.sqlteam.com/article/scripting-database-objects-using-smo-updated