How Can I Move Data From One Column Of A Parent Into A New Child Table?

I have two tables: WordForm and WordDefinition: CREATE TABLE [dbo].[WordForm] ( [WordFormId] VARCHAR (20) NOT NULL, [WordId] VARCHAR (20) NOT NULL, [Primary]

Solution 1:

I think you can just use 1 query INSERT INTO SELECT to do this, something like this:

INSERT INTO [dbo].[WordDefinition]
SELECT [WordFormId], [Definition] 
FROM [dbo].[WordForm]

After that you can delete the old column Definition from WordForm.