Table restore

is there any option in sql 2008 r2 to restore a table only not a hole db ?
because i have my RefObjCommon table got fucked up . so i want to delete it and copy new lines but i cant delete it . it gives an error .
(cannot truncate table Refobjcommon because it is being referenced by a FOREIGN KEY constraint

SELECT * INTO

what ?

can u explain more ? :P

I'm not an expert in sql but I think what lastthief is trying to say is that you could restore the database with an other name and execute a query like this:

SELECT *
INTO [SRO_SHARD_INIT]._RefObjCommon
FROM [SRO_SHARD_INIT_ORIGINAL]._RefObjCommon

Check the sql statement SELECT INTO if you want some more details:
[Only registered and activated users can see links. Click Here To Register...]