通过代码修改数据库中的字段和主外键

alter table [song]
add musictypeid int

alter table member
alter column ActiCode int not null

ALTER TABLE [dbo].[song] WITH CHECK ADD FOREIGN KEY([musictypeid])
REFERENCES [dbo].[musictype] ([id])
GO