Can we use Truncate command on a table which is referenced
by FOREIGN KEY?

Answer Posted / guest

No. We cannot use Truncate command on a table with Foreign
Key because of referential integrity.

Is This Answer Correct ?    18 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain a join?

623


what is the Ticketing tool used in Wipro technologies at Bangalore...???

7483


What are the difficulties faced in cube development? : sql server analysis services, ssas

614


What does the update command do?

617


Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

557






What is the difference between Clustered and Non-Clustered Index?

609


How to restore performance issues and how to check?

1529


Mention the differences between having and where clause.

561


What is temporary table in sql server? Why we use temp table?

525


Explain about remote stored procedure?

593


What information is maintained within the msdb database?

545


Define self join?

632


Does view occupy space?

522


What are sql azure firewall rules?

85


How can I create a report based on a query? : sql server management studio

567