SVB's assets will be divided up and given back to creditors (including depositors). So remaining depositors likely will get something back eventually, but we don't know how much yet (10%? 50%? 85%). There will also likely be a delay in getting those funds back as the process plays out, which is probably more dangerous to many companies than the haircut (assuming the hair-cut isn't too severe).
For full precision, if you're concerned about this, be aware that it's 250K per depositor at a given bank, rather than per account. That is, all your qualifying accounts at the bank are considered as one pool and 250K of that is insured. More detailed information, including how joint accounts are handled, here: https://www.fdic.gov/resources/deposit-insurance/financial-p...
Many bank's terms are if you get a loan from them, you need to use them as your only bank (or only accounts receiving deposits, or something). It is negotiable but it is the norm.