Can we use Truncate command on a table which is referenced
by FOREIGN KEY?
- 2 Answers
- 9147 Views
- Shriram, I also Faced
- E-Mail Answers
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
How to create an identity column?
What are different types of constraints?
How to remove duplicate rows from table?
What is triggers in ms sql server?
what is hash nonclustered index
What is the need for group functions in sql?
Explain intellisense for query editing
Can we do dml on views?
What is exporting and importing utility?
what is a join and explain different types of joins? : Sql server database administration
How to use column default values in insert statements in ms sql server?
Can you explain what are commit and rollback in sql?
How many clustered indexes there can be on table ?
What is an execution plan?
What is the chart in report?
