SQL::Translator::Producer::Sybase - Sybase producer for SQL::Translator

NAME  SYNOPSIS  DESCRIPTION  Sybase Create Table Syntax  Create Index Syntax  SEE ALSO  AUTHORS 

---

NAME

SQL::Translator::Producer::Sybase − Sybase producer for SQL::Translator

SYNOPSIS

use SQL::Translator;
my $t = SQL::Translator−>new( parser => '...', producer => 'Sybase' );
$t−>translate;

DESCRIPTION

This module will produce text output of the schema suitable for Sybase.

Sybase Create Table Syntax

CREATE [ [ LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name (
{ column_name data_type [ DEFAULT default_expr ] [ column_constraint [, ... ] ]
| table_constraint } [, ... ]
)
[ INHERITS ( parent_table [, ... ] ) ]
[ WITH OIDS | WITHOUT OIDS ]

where column_constraint is:

[ CONSTRAINT constraint_name ]
{ NOT NULL | NULL | UNIQUE | PRIMARY KEY |
CHECK (expression) |
REFERENCES reftable [ ( refcolumn ) ] [ MATCH FULL | MATCH PARTIAL ]
[ ON DELETE action ] [ ON UPDATE action ] }
[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]

and table_constraint is:

[ CONSTRAINT constraint_name ]
{ UNIQUE ( column_name [, ... ] ) |
PRIMARY KEY ( column_name [, ... ] ) |
CHECK ( expression ) |
FOREIGN KEY ( column_name [, ... ] ) REFERENCES reftable [ ( refcolumn [, ... ] ) ]
[ MATCH FULL | MATCH PARTIAL ] [ ON DELETE action ] [ ON UPDATE action ] }
[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]

Create Index Syntax

CREATE [ UNIQUE ] INDEX index_name ON table
[ USING acc_method ] ( column [ ops_name ] [, ...] )
[ WHERE predicate ]
CREATE [ UNIQUE ] INDEX index_name ON table
[ USING acc_method ] ( func_name( column [, ... ]) [ ops_name ] )
[ WHERE predicate ]

SEE ALSO

SQL::Translator.

AUTHORS

Sam Angiuoli <[email protected]>, Paul Harrington <[email protected]>, Ken Youens-Clark <[email protected]>.

---