From Dragon Age Wiki
Spells give mages the ability to devastate their foes and protect and heal their allies. Spells are used by mages instead of talents. Mage spells are divided into four "schools" of magic: Primal, Spirit, Creation, and Entropy.
These spell descriptions are taken from the NYCC demo, and may be subject to change.
1 Types of Spells
Types of Spells
ActivatedActivated spells have an original mana cost in order to cast it, but nothing further. After the initial cast, the mana cost is drained and the desired effect is achieved.
Sustained spells not only have an original mana cost for casting, but also a mana upkeep in order to keep the spell in effect. In example: A sustained spell requires 12 mana for the initial casting, as well as 20 mana in upkeep. This 20 mana would not be able to be used by your mage for other spells and if you slip below 20 mana, the spell would dissipate.
Creation spells allow mages to heal and boost their allies, as well as render certain foes harmless.
Heal > Cure > Regeneration > Purify
Heroic Offense > Heroic Aura > Heroic Defense > Haste
Glyph of Paralysis > Glyph of Warding > Glyph of Repulsion > Glyph of Neutralization
Spell Wisp > Grease > Spellbloom > Stinging Swarm
Entropy spells are all about crippling and damaging foes.
Weakness > Paralyze > Miasma > Mass Paralysis
Vulnerability Hex > Affliction Hex > Misdirection Hex > Death Hex
Daze > Horror > Sleep > Waking Nightmare
Drain Life > Death Magic > Curse of Mortality > Death Cloud
Primal spells involve dealing elemental damage to foes, and using the elements to protect yourself or your allies.
Flame Blast > Flaming Weapons > Fireball > Inferno
Rock Armor > Stonefist > Earthquake > Petrify
Winter's Grasp > Frost Weapons > Cone of Cold > Blizzard
Lightning > Shock > Tempest > Chain Lightning
Spells from the Spirit school allow one to enhance weapons, protect allies, and damage the very spirit of an enemy.
Spell Shield > Dispel Magic > Anti-Magic Ward > Anti-Magic Burst
Mana Drain > Mana Cleanse > Spell Might > Mana Clash
Walking Bomb > Death Syphon > Virulent Walking Bomb > Animate Dead
Mind Blast > Force Field > Telekinetic Weapons > Crushing Prison