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
- 10121 Views
- Shriram, I also Faced
- E-Mail Answers
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
what are constraints? Explain different types of constraints? : Sql server database administration
Write a SQL queries on Self Join and Inner Join.
In which format does an image save in SQL Server database ?
mention different types of relationships in the dbms?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
What is sql server profiler?
What is a covering index?
What the different types of Replication and why are they used?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What are the advantages of having an index on the sql server?
What is role playing dimension with two examples? : sql server analysis services, ssas
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
Can we perform backup restore operation on tempdb? : sql server database administration
Differentiate between a primary key and a unique key.
What is explicit mode in sql server?
