ROLE OF DELETE & DROP KEYWORD IN SQL/MYSQL/ACCESS
difference between delete and truncate in sql server,sql,delete,sql tutorial,difference between drop and truncate in mysql,difference between delete and truncate,sql server,sql (programming language),drop,difference between delete & truncate,difference between truncate and delete,difference between delete truncate and drop in sql server 2012,sql tutorial for beginners,difference between delete and truncate in sql server 2008,difference between delete and truncate in sql server with example
sql,delete,sql server,sql (programming language),drop,sql tutorial,sql delete,drop table in oracle sql,drop table in sql server,creating tables in sql,sql drop,drop table sql,delete vs trucate vs drop in sql,microsoft sql server,delete records in sql,delete table in sql server,how to delete database in sql server,drop in sql,delete vs drop,sql delete & drop
TRUNCATE is a DDL command
TRUNCATE is executed using a table lock and whole table is locked for remove all records.
We cannot use Where clause with TRUNCATE.
TRUNCATE removes all rows from a table.
Minimal logging in transaction log, so it is performance wise faster.
TRUNCATE TABLE removes the data by deallocating the data pages used to store the table data and records only the page deallocations in the transaction log.
Identify column is reset to its seed value if table contains any identity column.
To use Truncate on a table you need at least ALTER permission on the table.
Truncate uses the less transaction space than Delete statement.
Truncate cannot be used with indexed views.
DELETE is a DML command.
DELETE is executed using a row lock, each row in the table is locked for deletion.
We can use where clause with DELETE to filter & delete specific records.
The DELETE command is used to remove rows from a table based on WHERE condition.
It maintain the log, so it slower than TRUNCATE.
The DELETE statement removes rows one at a time and records an entry in the transaction log for each deleted row.
Identity of column keep DELETE retain the identity.
To use Delete you need DELETE permission on the table.
Delete uses the more transaction space than Truncate statement.
Delete can be used with indexed views.
The DROP command removes a table from the database.
All the tables' rows, indexes and privileges will also be removed.
No DML triggers will be fired.
The operation cannot be rolled back.
DROP and TRUNCATE are DDL commands, whereas DELETE is a DML command.
DELETE operations can be rolled back (undone), while DROP and TRUNCATE operations cannot be rolled back.
#HindiTutorial #DilipSir #askDilipSir #Youtuber #YouTube #you_tuber
#Dilip #sir #india #tech #technology #videos #best #tutorial #how
#know_how #CSharp #Excel #Word #HTML #CSS #ComputerTips_Tricks
#ASP.net #WinFormApp #HowtoFix #VisualStudio #MSPowerPoint
#OutLook #SQL #Hindi #Urdu #SocialTech #Facebook #GamePlays
#gameplay #game_play #playGame #CallofDuty #CsharpinHindi #HTML5
#IA, #RRB, #IBPS, #SSC, #UPPSC, #2nd Grade, #LDC, #POLICE, #COMPUTER, #RAILWAY, #ASSISTANT, #TEACHER
Looking for someone like-minded? Chances are you’ve already got one thing in common.
15,000 New members.
Soulmates sees over 15,000 new faces every month.
#1 Customer service.
Feel safe and secure, with help from our award-winning customer service team.
Recently joined Soulmates.
Meet some of our latest members.
Online Dating Success Stories.
Intrepid explorers who’ve found the person of their dreams.
Kristian & Zoe.
"We met through Soulmates four years ago. Although were both based in London, the chances of us meeting by other means were slim. We just got married! Zoe is the most wonderful woman Ive ever met, and I know we are going to have an extremely happy life together."
Laura & Phil.
"Phil and I got married just over a year after we met on my first ever internet date through Guardian Soulmates. Weve been recommending the site to friends ever since. Thank you!" (Photography credit to Michael OSullivan)
Robin & Alec.
"I just wanted to let you know that you have another success story! My boyfriend, who I met via your site about two years ago, just proposed and we are getting married next year. THANK YOU!"
Alex & Rosie.
"Rosie and I met through Soulmates and were married in October, just 17 months later. Were wonderfully happy together!"
How does it work?
Find your Soulmate in three easy steps.
Register your free account today.