Partioning table

[geeeeeeeetha]

Hi, I'm having table like empid,empname,cityname,statename,countryname. how to splitt this table structure. Regards Bharathi

[Mycroft Holmes]

Partitioning a table is NOT what you want to do, that is dealing with VERY large tables and requires DBA skills. You are after a data structure. You have 3 tables crammed into 1.

Employee
EmployeeID
EmployeeName
StateID

Country
CountryID
CountryName

State
StateID
CountryID
StateName

Employee View

Select *
From Employee E
Inner Join State S on S.StateID = E.StateID
Inner Join Country C on C.CountryID = S.CountryID

Never underestimate the power of human stupidity RAH