Bukhari

Hadith Commentary:
Hazrat Umar radi Allahu anhu stated this before all the Companions for years, and all remained silent, which amounts to consensus (ijma‘). Now, how can the statement of just one, Ibrahim al-Nakha‘i, be considered proof against this consensus? And it is astonishing regarding the Hanafis that they abandon the authentic hadith and persist in adhering to an incorrect ruling.

The people of Madinah, all the Hijazis, and all the scholars of hadith have said: “Every intoxicant is wine (khamr), and its ruling is the same as that which is made from grapes,” etc. (Fath)

The author of al-Hidayah says that wine (khamr) is only that which is prepared from raisins. In response to this, Hafiz Ibn Hajar states that the people of Madinah, rather all the Hijazis, and all the scholars of hadith, their unanimous statement is that every intoxicating substance is wine (khamr), and its ruling is the same as that of wine prepared from raisins.

For further details, refer to Fath al-Bari, volume twelve, page 146.

Hadith Commentary:
(1)
This hadith also refutes those who claim that wine (khamr) is only that which is made from grapes. Rather, from this hadith it is understood that anything which veils the intellect, regardless of the substance from which it is produced, is called khamr in Arabic and is prohibited.
(2)
The medicines used to induce unconsciousness during operations do not fall under the ruling of intoxicants, because there is a clear difference between unconsciousness and intoxication. However, such medicines are also permissible for treatment when there is a need; to render oneself senseless without necessity is not permissible.
And Allah knows best.