Thread: Details for ShippingMethod Allowed States

I have added a full list of states/proviences by inserting into [dbo].State

I now need to assign these new states to the correct shipping method and its allowed states. What is the correct [dbo] to use for this? I used to know this but lost the file containing the information, I thought it might be something along the lines of...

INSERT [dbo].ShippingMethodSetAllowedStates

Unfortunately, I don't have direct access to the database structure to see all the names and have been unsuccessful searching the forums.

Could the details be provided as well, as in the example below for [dbo].State

INSERT [dbo].State(CountryID,Name,Abbreviation,DisplayOrder)

INSERT INTO [dbo].[ShippingMethodToStateMap]
([ShippingMethodID]
,[StateID]
,[CreatedOn])
VALUES
(<ShippingMethodID, int,>
,<StateID, int,>
,<CreatedOn, datetime,>)
GO

fantastic
thanks for the info george!