Access Database to include Default constraint on a newly added column through ALTER script from a application. RRS feed

  • Question

  • Hi ,

    I am facing  problem  while  including Default constraint  for a newly added column  through ALTER  script from a application.     It is  simple and straight forward  in SQL  server as below:                                                                                                 [ALTER TABLE  <TABLENAME> ADD <COLUMN> NUMERIC(5) NOT NULL DEFAULT 0]

    i need something simple as this.

    I don't  want to run update  scripts as solution for this problem on  creation of new  column because  next time any data inserted  the columns will be left again blank.

    Thanks in Advance.

    Thursday, January 3, 2019 6:08 AM