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

Answer Posted / samji

Cacase can be used to delete a table which is referenced
by FOREIGN KEY

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is xml datatype?

659


What does man by sql wildcard characters in sql server?

527


How to select an exiting database using mssql_select_db()?

509


What are pessimistic lock and optimistic lock?

550


How many types of subqueries are there in sql server?

469






What are the advantages of partitioning?

646


Can we use max in where clause?

519


What are diverse clauses that form a part of sql?

601


How to implement service broker?

527


What is stored in the mssqlsystemresource database? : sql server database administration

596


Explain the steps to create and execute a user-defined function in the sql server?

532


what is denormalization and when would you go for it? : Sql server database administration

707


Determine when an index is appropriate?

558


Do you know the capabilities of cursors?

533


What are the differences between stored procedure and view in sql server?

627