—SQL :
structured query language
—SQL
is a standard language for accessing and manipulating databases..
Understanding DDL
—DDL : data
definition language it
deals
with creating
database objects like tables,
views, constraints,
and stored procedures.
the four main DDL statements are as follows:
—•
USE: Changes the database context.
—•
CREATE: Creates a SQL Server database object (table, view, or stored
procedure).
—•
ALTER: Changes an existing object.
•
DROP: Removes an object from the database
Understanding DML
—DML:
data manipulation language
—SELECT:
Retrieves rows from the database and enables the selection of one or many rows
—or
columns from one or many tables in SQL Server.
—•
INSERT: Adds one or more new rows to a table or a view in SQL Server.
—•
UPDATE: Changes existing data in one or more columns in a table or view.
—•
DELETE: Removes rows from a table or view.
Understanding DCL
—Grant:
to give permission on object to user
—Revoke
: to cancel permission from user
المشاركات
ليست هناك تعليقات:
إرسال تعليق