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]]

Re: get create table script for a SQL Server object

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" <tony_ooooo@yah oo.comschreef in bericht
news:1157198058 .567474@angel.a mnet.net.au...

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.
>

[arch]

Re: get create table script for a SQL Server object using VB.Net

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]" <notmyfirstname @planet.nlwrote in message
news:OFbcFqozGH A.3908@TK2MSFTN GP05.phx.gbl...

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" <tony_ooooo@yah oo.comschreef in bericht
news:1157198058 .567474@angel.a mnet.net.au...

>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]]

Re: get create table script for a SQL Server object using VB.Net

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

"arch" <tony_ooooo@yah oo.comschreef in bericht
news:1157199898 .983748@angel.a mnet.net.au...

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]" <notmyfirstname @planet.nlwrote in message
news:OFbcFqozGH A.3908@TK2MSFTN GP05.phx.gbl...

>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" <tony_ooooo@yah oo.comschreef in bericht
>news:115719805 8.567474@angel. amnet.net.au...

>>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.
>>>

>>
>>

>
>