Add a column with a default value

Archive
1

Hello,

Consider that i have an Order Detail table like as bellow :

 create table tbl_orderDetail(
  id_OrderDetail int,
  id_product int,
  id_order int,
  Quantity int,
  price double
  )

The order detail table is a huge table (more than 80 millions rows)

Now, i want to add a new column on that table “id_orderDetail_Status” this new column contains a default value for the old data.

How can i add the column without crushing my old table ?

There are any solution for that ?

Thanks