To dream that you are in school signifies feelings of inadequacy and childhood insecurities that have never been resolved. It may relate to anxieties about your performance and abilities. If you are still in school and dream about school, then the dream may just be a reflection of your daily life and has no special significance.
Alternatively, a dream that takes place in school may be a metaphor for the lessons that you are learning from your waking life. You may be going through a “spiritual learning” experience.
To dream that you are looking for a school suggests that you need to expand your knowledge and learning. To dream that you are at a new school means that you are feeling out of place in some situation. Or perhaps there is a new lesson that you need to learn.
To dream that your childhood school is in ruins suggests that you are dwelling on some unresolved childhood issue. Alternatively, the dream represents the passage of time. You need to look toward the future instead of reliving the past.