Need to create tables with different culture

[Satish Developer]

Hi, I have a requirement that as follows In front end i have a dropdown with options English, Spanish, German, chinese, Japan etc. What ever the language i have selected in dropdown, i need to create a table to store the corressponsindg language data. I am not knowing how to create a table with culture specific? For each language, different table to be created. Can any one help on this? If possible, plz provide code for me. or modify the below code This code is general for creating a table CREATE TABLE [dbo].[Tbl_Names] ( [SeedID] [int] IDENTITY(1,1) NOT NULL, [Indian_First_Names] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Indian_Last_Names] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Gender] [varchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Culture] [varchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ) ON [PRIMARY]

G. Satish

[mghiassi]

you must use two table with foreign key in another table. One table include (SeedID,FirstName,LastName,Gender and CultureID foreign key) and another table include(CultureID PrimeryKey,Culture)