restore single table

Hello All:

I need guidance on how move some changes that I have made to my
production database.

On my development database I made changes to a table called DEPT. I
added a column, added

a couple of records and did some general data cleanup

What I did not do was change any of the keys on existing records. The
primary key of DEPT is a

foreign key in several other tables.

Here is my question: Can I do a table restore on to the production
database and expect these

changes to be moved over? Will the restore handle, via some magic,
"suspend" the foreign key

constraints and allow the new table structure to be created and then
populated with new data.

I have not changed the keys of existing records so that existing
relationships should be restored.

Thanks for considering my issue.

Kevin Duffy