How to alter table from C# code

Question

I want to add one column to an existing table in C#, if it doesn't already exist. I know I have to use an 'alter table' command.

But I am not able to fire that command in my C# code.
How can I do?

I'm using Visual Studio 2010 and Sql Server 2008.

possible duplicate of C# Alter Table and Add a column programmatically ASP.Net & SQL Server — Rajesh
– Rajesh, Commented Mar 18, 2015 at 7:23
Fixed some grammar and formatting, Removed irrelevant greetings and thanks — Phantômaxx
– Phantômaxx, Commented Mar 18, 2015 at 11:31

Andriy M · Accepted Answer · 2015-03-18 08:49:25Z

0

this :

Use [DatabaseName]
Go
if Not exists( Select * from sys.columns As clm
                where clm.object_id = OBJECT_ID(N'[TableName]')
                And clm.name = N'[ColumnName]'
              )
Begin

    Alter Table TableName
    Add ColumnName DataTypeName

End

edited Mar 18, 2015 at 8:49

Andriy M

78k18 gold badges100 silver badges157 bronze badges

answered Mar 18, 2015 at 7:39

Iraj

1,5325 gold badges18 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Prafull Bansode Over a year ago

thnx user3540365, Rajesh and raj. I appreciate your help.

Collectives™ on Stack Overflow

How to alter table from C# code

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related