Creating Schema

30 Dec 2005 4:30 PM

Jack

In ADO.Net, can I create "create table ( ... )", "alter table ..." stuff,
and execute it to create my schema for MS-SQL2000?

Jack

30 Dec 2005 7:03 PM

W.G. Ryan - MVP

jack:

Are you asking if you can write DDL Statements and Execute them against Sql
Server? If yes, than the answer is yes. Just set the commandtext property
of you SqlCommand object to the DDL Statement and use ExecuteNonQuery
afterward.
Show quote

"Jack" <jack@no_spam.com> wrote in message
news:%23%23d1m5VDGHA.2320@TK2MSFTNGP11.phx.gbl...
> In ADO.Net, can I create "create table ( ... )", "alter table ..." stuff,
> and execute it to create my schema for MS-SQL2000?
>
> Jack
>

31 Dec 2005 10:41 AM

Sahil Malik [MVP C#]

Yes you can.

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
__________________________________________________________

Show quote

"Jack" <jack@no_spam.com> wrote in message
news:%23%23d1m5VDGHA.2320@TK2MSFTNGP11.phx.gbl...
> In ADO.Net, can I create "create table ( ... )", "alter table ..." stuff,
> and execute it to create my schema for MS-SQL2000?
>
> Jack
>

2 Jan 2006 4:35 PM

Jack

Thanks very much

Show quote

"Sahil Malik [MVP C#]" <contactmethrumyblog@nospam.com> wrote in message
news:%23IGoTbfDGHA.208@tk2msftngp13.phx.gbl...
> Yes you can.
>
> - Sahil Malik [MVP]
> ADO.NET 2.0 book -
> http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
> __________________________________________________________
>
>
> "Jack" <jack@no_spam.com> wrote in message
> news:%23%23d1m5VDGHA.2320@TK2MSFTNGP11.phx.gbl...
>> In ADO.Net, can I create "create table ( ... )", "alter table ..." stuff,
>> and execute it to create my schema for MS-SQL2000?
>>
>> Jack
>>
>
>