https://sqlines.com/ 2026-05-02T00:52:36+00:00 https://sqlines.com/ https://sqlines.com/lib/images/favicon.ico text/html 2012-03-28T08:11:16+00:00 https://sqlines.com/sybase-asa/autoincrement_identity?rev=1332922276&do=diff DEFAULT AUTOINCREMENT and IDENTITY properties allow you to automatically generate unique integer numbers (IDs, sequences) for a column in Sybase ASA. Quick Example: -- Define a table with DEFAULT AUTOINCREMENT (id starts at 1) CREATE TABLE cities ( id INTEGER DEFAULT AUTOINCREMENT, name VARCHAR(90) ); -- Insert a row, ID will be automatically generated INSERT INTO cities (name) VALUES ('San Francisco'); -- Retrieve generated ID SELECT @@IDENTITY; … text/html 2012-03-21T09:21:21+00:00 https://sqlines.com/sybase-asa/datatypes?rev=1332321681&do=diff The reference and articles provide detailed technical information on built-in data types in Sybase SQL Anywhere and their equivalents in other databases. Last Update: Sybase SQL Anywhere 12.0 Date Type Mapping to Other Databases Sybase SQL Anywhere data type mapping for migration to other databases: text/html 2012-03-26T09:53:10+00:00 https://sqlines.com/sybase-asa/default?rev=1332755590&do=diff The DEFAULT clause allows you specifying the default value for a column. The default value is assigned if you omit the column or specify DEFAULT keyword in a INSERT statement. Quick Example: -- Create a table CREATE TABLE teams ( id int, name VARCHAR(80) DEFAULT 'N/A' ); -- Insert default value 'N/A' to name column INSERT INTO teams(id) VALUES (1); INSERT INTO teams VALUES (2, DEFAULT); -- Insert default values to all columns INSERT INTO teams DEFAU… text/html 2012-03-29T11:54:08+00:00 https://sqlines.com/sybase-asa/functions?rev=1333022048&do=diff The reference and articles provide detailed technical information on built-in SQL functions in Sybase SQL Anywhere. Last Update: Sybase SQL Anywhere 12.0 All Functions Functions in alphabetical order: 1 DATEFORMAT Convert datetime to string using specified format 2 STRING Concatenate strings String Functions 1 DATEFORMAT Convert datetime to string using specified format 2 STRING Concatenate strings Conversion and Format Functions Conversion and format functions: text/html 2012-03-29T10:34:56+00:00 https://sqlines.com/sybase-asa/key_join?rev=1333017296&do=diff KEY JOIN clause allows you joining 2 or more tables based on their foreign key relationship, and does not require specifying columns and ON condition. Quick Example: -- Define a parent table CREATE TABLE states ( abbr CHAR(2) NOT NULL PRIMARY KEY, name VARCHAR(90) ); -- Define a child table CREATE TABLE cities ( name VARCHAR(90), state CHAR(2) REFERENCES states ); -- Querying tables using KEY JOIN SELECT c.name, s.name FROM citie… text/html 2017-12-20T16:32:02+00:00 https://sqlines.com/sybase-asa/locale_information?rev=1513787522&do=diff You can use the following queries to obtain the locale information from Sybase SQL Anywhere database server: Sybase ASA: -- Get the character set of the database server SELECT PROPERTY('CharSet'); # windows-1252 -- Get the character set used to store CHAR data in the database SELECT DB_PROPERTY('CharSet'); # windows-1252 -- Get the character set used to store NCHAR data in the database SELECT DB_PROPERTY('NcharCharSet'); # UTF-8 -- Get the client's character s… text/html 2012-04-02T09:55:12+00:00 https://sqlines.com/sybase-asa/statements?rev=1333360512&do=diff The reference and articles provide detailed technical information on SQL statements in Sybase SQL Anywhere and their equivalents in other databases. Last Update: Sybase SQL Anywhere 12.0 SQL Statements Conversion to Other Databases Sybase SQL Anywhere statements conversion to other databases: