get create table script for a SQL Server object

2 Sep 2006 12:11 PM

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.

2 Sep 2006 12:24 PM

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

Show quoteHide quote

"arch" <tony_oo***@yahoo.com> schreef in bericht
news:1157198058.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.
>

2 Sep 2006 12:42 PM

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.

Show quoteHide quote

"Cor Ligthert [MVP]" <notmyfirstn***@planet.nl> wrote in message
news:OFbcFqozGHA.3908@TK2MSFTNGP05.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_oo***@yahoo.com> schreef in bericht
> news:1157198058.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.
>>
>
>

2 Sep 2006 2:56 PM

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

Show quoteHide quote

"arch" <tony_oo***@yahoo.com> schreef in bericht
news:1157199898.983748@angel.amnet.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]" <notmyfirstn***@planet.nl> wrote in message
> news:OFbcFqozGHA.3908@TK2MSFTNGP05.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_oo***@yahoo.com> schreef in bericht
>> news:1157198058.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.
>>>
>>
>>
>
>