Interested to Buy Any Domain ? << Click Here >> for more details...
Can we use Truncate command on a table which is referenced
by FOREIGN KEY?
- 2 Answers
- 10276 Views
- Shriram, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / samji
Cacase can be used to delete a table which is referenced
by FOREIGN KEY
| Is This Answer Correct ? | 5 Yes | 2 No |
In which format does an image save in SQL Server database ?
How to swap the data of two columns in a table. both the columns containing varchar values.
What is a trigger and its types?
Explain ranking functions?
When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO
What are acid properties of transaction?
Why truncate is ddl?
How to list all user defined functions in the current database?
How to replace the Query Result 'Null Value' with a text ?
Can you explain what is the use of custom fields in report?
internal language used in sql server 2000?
what stored procedure would you use to view lock information? : Sql server administration
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
