Concrete that is self-compacting or self-consolidating is referred to as SCC with unique properties such as flowability, self-consolidation, and workability and it can be placed in any type of Reinforced cement concrete (RCC) work where reinforcements are congested and not able to do compaction. In this fast-moving modern era, the role of SCC is unavoidable. It is an advanced method of concreting and sustainable materials that can be utilized as an alternative to river sand or crushed stone sand which includes waste foundry sand, steel slag, stainless steel slag, and iron slag, among others. These materials are the product of industries and create dumping problems in the environment. These materials have a similar composition to fine aggregate there for can be replaced by some percentage with fine aggregate. To bring an alternative to existing river sand and to prevent sand mining In this novel paper detailed investigation has been made to review different sustainable material as fine aggregate and a critical review is done about the SCC features (fresh and hardened) produced using waste foundry sand, steel slag, stainless steel slag and iron slag respectively. In addition, mechanical properties along with microstructure studies of different sustainable fine aggregates are discussed. The optimum substitution rate for sustainable fine aggregate and its benefits are studied. All the alternative fine aggregate has made a significant impact on fresh and hardened properties. Due to their unique performance, various fine aggregates notably waste foundry sand, steel slag, stainless steel slag and iron slag can be employed in making SCC.