Answer Posted / kunal sain
to drop the constraint from child table when dropping the
constraint from parent table.
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What is difference between delete and truncate commands?
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
Explain about sql server login?
How to change parameter value inside the report?
What is the library index called?
Explain the stored procedure?
How to set a database state to offline in ms sql server?
Explain different types of locks in sql server.
How can I track the changes or identify the latest insert-update-delete from a table?
what is the main function of a query parameter?
What is the impact on other user sessions when creating indexes?
what's the difference between delete table and truncate table commands? : Sql server database administration
What is transaction server auto commit?
Explain different backup plans?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?