Is there chance to restore deleted column in ASPNETDB?

I deleted "UserName" column in aspnet_Users (ASPNETDB) is there chanse to restore it? I can开发者_Python百科't just add that column it will change schema.

What adding the column it would be a schema change?

If you have a backup, restore it with another database name. Add the column to your table and then update the column using join to the database table of the backup

Eg.

UPDATE a SET a.UserName = b.UserName FROM mydb1.dbo.table1 AS a INNER JOIN mybackupdb1.dbo.table1 AS b WHERE a.id = b.id