National Drug Code

SQL procedures to define the tables and load the data are provided below. This SQL has been tested using MySQL and SQLite but should work for other SQL92 compliant databases. These are just examples. To obtain more SQL, data and procedures, please download the zip file from our downloads page (or obtain the zip file directly here, which is about 9.1 MB).

--;
-- process ndc codes from USDA site;
-- process ndc codes downloaded from http://www.fda.gov/cder/ndc;
--
-- drop the firms table
drop table firms;
--
-- create the firms table
create table firms(seqno varchar(10),
lblcode varchar(20), firmname varchar(100),
addr varchar(100), street varchar(40),
pobox varchar(40), foreign2 varchar(40),
city varchar(40), state varchar(40),
province varchar(40), zipcode varchar(40));
--
-- load the firms table with data
load data local infile 'c:/data/ndc/firms.tab' into table firms ignore 1 lines;