• It seems to me that schemas need to be part of the initial database design and will be used mainly for larger databases that need a formal design phase.

    Many departmental databases started life as someone's informal personal project and are unlikely to have well thought-out schemas. And once they are in general use it is almost impossible to retro-fit schemas without breaking the automation and reporting scripts that will have sprung up around it.