Connecting Tech Pros Worldwide Help | Site Map

Creating a new field in MS SQL server

Maziar Aflatoun
Guest
 
Posts: n/a
#1: Nov 15 '05
Hi,

Does anyone know how I can create/remove table fields in Microsoft SQL
server using C# code?

Thank you
Maziar A.


William Ryan
Guest
 
Posts: n/a
#2: Nov 15 '05

re: Creating a new field in MS SQL server


Assuming you have the permissions to allow you to do this, simple use a
stringbuilder to construct a DDL statement and set the commandtext of your
command object to it, coupled with an ExecuteNonQuery...


"Maziar Aflatoun" <maz88@rogers.com> wrote in message
news:9Drtb.71058$Rah1.67074@twister01.bloor.is.net .cable.rogers.com...[color=blue]
> Hi,
>
> Does anyone know how I can create/remove table fields in Microsoft SQL
> server using C# code?
>
> Thank you
> Maziar A.
>
>[/color]


Closed Thread