It is used to retrieve, store, modify, delete, insert and update data in database. It is used to create and modify the structure of database objects in database. It is used to create roles, permissions, and referential integrity as well it is used to control access to database by securing it. It is used to manage different transactions occurring within a database.
Sooria, Delete command deletes the rows one by one and maintains a log for every action. Delete does not play at table level whereas drop simply delete the table as well.
Hi adilti, It is absolutely fine, you can use these commands on any platform that supports sql server. Find the employees in data base who lives in same city and on the same street of their manager 2. Drop command would remove the object table completely. In my Comprehensive Database Performance Health Check , we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future. Leave new Alexander Zaltsman. Rahul Diwakar. Pinal Dave. Its query to find details from WMI. Vivek Verma. Simha Nara Simha. Transaction control language or TCL commands deal with the transaction within the database. What is DQL? It uses only one command:. Report a Bug. Previous Prev. Next Continue. Home Testing Expand child menu Expand.
SAP Expand child menu Expand. Web Expand child menu Expand.
0コメント