changing null to not null in postgresql via c#

Question

I have a PostgreSql DB connected to Visual Studio. I want to change a column(what column I want) from null to not null via Visual Studio. How I can do that? Can't find this on internet.

postgresql.org/docs/9.1/static/sql-altertable.html

mjwills
– mjwills

2018-06-13 12:24:20 +00:00
Commented Jun 13, 2018 at 12:24 — mjwills
– mjwills, Commented Jun 13, 2018 at 12:24
@mjwills I don't know how to do it. I'm a little rockie ^^

vladl
– vladl

2018-06-13 12:33:32 +00:00
Commented Jun 13, 2018 at 12:33 — vladl
– vladl, Commented Jun 13, 2018 at 12:33

Save · Accepted Answer · 2018-06-13 12:30:59Z

1

Try this code:

SqlConnection sqlConnection1 = new SqlConnection("Your Connection String");
SqlCommand cmd = new SqlCommand();
SqlDataReader reader;

cmd.CommandText = "ALTER TABLE YourTableName ALTER COLUMN YourColumnName DROP NOT NULL;";
cmd.CommandType = CommandType.Text;
cmd.Connection = sqlConnection1;

sqlConnection1.Open();

reader = cmd.ExecuteReader();
// Data is accessible through the DataReader object here.

sqlConnection1.Close();

answered Jun 13, 2018 at 12:30

Save

384 bronze badges

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

1 Comment

vladl Over a year ago

Where I should put that?

Collectives™ on Stack Overflow

changing null to not null in postgresql via c#

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related