Tuesday, September 6, 2011

How many types of control statements are present in Sybase ASE?

Adaptiver Server Enterprise provides four different types of control statements for performing various tasks in database. These different types of control statements in Sybase are -

  1. DDL or Data Definition Language statements - These are the statements that are being used to define various database objects or alter them. Some of such statements are - create table, create view, alter table etc.
  2. DML or Data Manipulation Language statements - These are the control statements which are used to do various manipulations on the data stored in various database objects. Some such statements are - insert into, update, delete etc.T
  3. TCL or Transaction Control Language statements - These are statements which are being used to control transactions in Sybase database. Example - begin tran, commit tran, savepoint etc.
  4. DCL or Data Control Language statements - These are statements which are used to provide security access to various database objects. Example - grant and revoke.

No comments:

Post a Comment