The pyridine nucleotide NAD+ is derived from dietary niacin and serves as the substrate for the synthesis of cyclic ADP-ribose (cADPR), an intracellular Ca signalling molecule that plays an important role in synaptic plasticity in the hippocampus, a region of the brain involved in spatial learning. cADPR is formed in part via the activity of the ADP-ribosyl cyclase enzyme CD38, which is widespread throughout the brain. In the present review, current evidence of the relationship between dietary niacin and behaviour is presented following investigations of the effect of niacin deficiency, pharmacological nicotinamide supplementation and CD38 gene deletion on brain nucleotides and spatial learning ability in mice and rats. In young male rats, both niacin deficiency and nicotinamide supplementation significantly altered brain NAD+ and cADPR, both of which were inversely correlated with spatial learning ability. These results were consistent across three different models of niacin deficiency (pair feeding, partially restricted feeding and niacin recovery). Similar changes in spatial learning ability were observed in Cd38− / −  mice, which also showed decreases in brain cADPR. These findings suggest an inverse relationship between spatial learning ability, dietary niacin intake and cADPR, although a direct link between cADPR and spatial learning ability is still missing. Dietary niacin may therefore play a role in the molecular events regulating learning performance, and further investigations of niacin intake, CD38 and cADPR may help identify potential molecular targets for clinical intervention to enhance learning and prevent or reverse cognitive decline.