Table restore

[Raptursh]

is there any option in sql 2008 r2 to restore a table only not a hole db ?
because i have my RefObjCommon table got ****** 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

[LastThief*]

SELECT * INTO

[Raptursh]

what ?

can u explain more ? :P

[kevin_owner]

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: