Nigerian Banks SQL Database

In this article, i will be providing a complete list of commercial Nigerian Bank Names and Codes in SQL Format.

This is useful to developers, especially in the case when you intend to create a dynamic dropdownlist in your forms for your users to select bank using a select field. You can populate your select field from your database using this SQL codes below.

--
-- Table structure for table `banks`
--

CREATE TABLE `banks` (
  `id` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `code` varchar(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `banks`
--

INSERT INTO `banks` (`id`, `name`,`code`) VALUES
(1, 'Access Bank','044'),
(2, 'Citibank','023'),
(3, 'Diamond Bank','063'),
(4, 'Dynamic Standard Bank',' '),
(5, 'Ecobank Nigeria','050'),
(6, 'Fidelity Bank Nigeria','070'),
(7, 'First Bank of Nigeria','011'),
(8, 'First City Monument Bank','214'),
(9, 'Guaranty Trust Bank','058'),
(10, 'Heritage Bank Plc','030'),
(11, 'Jaiz Bank','301'),
(12, 'Keystone Bank Limited','082'),
(13, 'Providus Bank Plc','101'),
(14, 'Polaris Bank','076'),
(15, 'Stanbic IBTC Bank Nigeria Limited','221'),
(16, 'Standard Chartered Bank','068'),
(17, 'Sterling Bank','232'),
(18, 'Suntrust Bank Nigeria Limited','100'),
(19, 'Union Bank of Nigeria','032'),
(20, 'United Bank for Africa','033'),
(21, 'Unity Bank Plc','215'),
(22, 'Wema Bank','035'),
(23, 'Zenith Bank','057');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `banks`
--
ALTER TABLE `banks`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `banks`
--
ALTER TABLE `banks`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

Thank you