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 ?