Data Manipulation Language (DML) Delete on SQL Server 2005


education dml sql server
one of the most frequently used functions are also in the data manipulation language is deletion of data,
This function is used when we want to delete the data already in the insert through syntax dml insert data. syntax
This really serves to erase the data that we want

The delete command is used to delete the data in the table
syntax for the delete command structure is as follows:
DELETE FROM [Table Name]
sample data deletion using the following criteria:
DELETE FROM [table name] WHERE <field name> = <kondisi>

Examples of the use of the delete DML syntax:
DELETE FROM t_user

To delete data using the following criteria:
example:
DELETE FROM t_user WHERE username = 'fahmi'

Comments