get create table script for a SQL Server object

[arch]

Is there a function or something I can use to generate an sql script for an
object in an sql server. for example, I want to generate the CREATE TABLE
AS .... statement for a table. I don't want to use SMO or DMO but some kind
of .net functionality.

 

[Cor Ligthert [MVP]]

Arch,

This is a SQL language problem, this newsgroup is about the VB.net language.
Even if you use a tool deditcated for for VB.Net.

By instance in the Managedment Tool for SQL server is this integrated,
however this is than more a question for the newsgroups ab out SQL
programming.

I hope this helps sofar,

Cor

 

[arch]

Perhaps I didn't make myself clear. I want to use VB.Net to generate the
SQL for an sql server table. Is this possible? There is no way this can be
done via Transact-SQL or any programming on the SQL Server (than I am aware
of). I was hoping there was some class library or something within the .Net
framework that could do this.

 

[Cor Ligthert [MVP]]

arch,

There is at the moment not any class/method that will do that, I wished that
it could be done from an XSD or/and XML file. But both are still not
possible. It is a wish from the first moment from many dotNet developers.

Cor