Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 17

SQL Anywhere Server - SQL Usage

This book describes how to add objects to a database; how to import, export, and modify data; how to retrieve data; and how to build stored procedures and triggers.


In this section:
    Tables, views, and indexes
    Tables, views, and indexes hold data within the database.
    Stored procedures, triggers, batches, and user-defined functions
    Procedures and triggers store procedural SQL statements in a database.
    Queries and data modification
    Many features are provided to help you query and modify data in your database.
    SQL dialects and compatibility
    Information about compliance is provided in the reference documentation for each feature in the software.
    XML in the database
    Extensible Markup Language (XML) represents structured data in text format. XML was designed specifically to meet the challenges of large-scale electronic publishing.
    JSON in the database
    JavaScript Object Notation (JSON) is a language-independent, text-based data interchange format developed for the serialization of JavaScript data.
    Data import and export
    The term bulk operations is used to describe the process of importing and exporting data.
    Remote data access
    Remote data access gives you access to data in other data sources as well as access to the files on the computer that is running the database server.
    Data integrity
    Data integrity means that the data is valid (correct and accurate) and the relational structure of the database is intact.
    Transactions and isolation levels
    Transactions and isolation levels help to ensure data integrity through consistency.
    The SQL Anywhere debugger
    You can use the SQL Anywhere debugger to debug SQL stored procedures, triggers, event handlers, and user-defined functions you create.