text: USE NPPES
  CREATE TABLE [dbo].[prov_loc];
  GO
  CREATE TABLE [dbo].[prov_loc] (
  	[NPI] numeric,
  	[Provider_Secondary_Practice_Location_Address_Line1] varchar(55),
  	[Provider_Secondary_Practice_Location_Address_Line2] varchar(55),
  	[Provider_Secondary_Practice_Location_Address_City_Name] varchar(40),
  	[Provider_Secondary_Practice_Location_Address_State_Name] varchar(40),
  	[Provider_Secondary_Practice_Location_Address_Postal_Code] varchar(20),
  	[Provider_Secondary_Practice_Location_Address_Country_Code] varchar(2),
  	[Provider_Secondary_Practice_Location_Address_Telephone_Number] varchar(20),
  	[Provider_Secondary_Practice_Location_Address_Telephone_Ext] varchar(20),
  	[Provider_Secondar_Practice_Location_Address_Fax_Number] varchar(20),
  )
  CREATE INDEX prov_loc_idx on [dbo].[prov_loc] (NPI);
  GO
  