1. Science
  2. Publications
  3. Information Processing Systems
  4. 8(106)'2012
  5. THE FEATURE OF USE SQL DATA DEFINITION LANGUAGE IN MODERN DBMS

THE FEATURE OF USE SQL DATA DEFINITION LANGUAGE IN MODERN DBMS

O.V. Tarasov
Annotations languages:

The article describes the syntax features in SQL Data definition language of modern DBMS, such as Access, Microsoft SQL Server, Oracle and DB2 in terms of the mobility of the script to create a main database objects during the transition to another platform. Discussed the main points to be brought to account in the implementation of such a practical problem.
Keywords: SQL language, data type, referential integrity, a surrogate key