1SQL::Translator::ProducUesre:r:SCyobnatsrei(b3u)ted PerlSQDLo:c:uTmreanntsaltaitoonr::Producer::Sybase(3)
2
3
4

NAME

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

SYNOPSIS

9         use SQL::Translator;
10
11         my $t = SQL::Translator->new( parser => '...', producer => 'Sybase' );
12         $t->translate;
13

DESCRIPTION

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

Sybase Create Table Syntax

18         CREATE [ [ LOCAL ] { TEMPORARY | TEMP } ] TABLE table_name (
19             { column_name data_type [ DEFAULT default_expr ] [ column_constraint [, ... ] ]
20             | table_constraint }  [, ... ]
21         )
22         [ INHERITS ( parent_table [, ... ] ) ]
23         [ WITH OIDS | WITHOUT OIDS ]
24
25       where column_constraint is:
26
27         [ CONSTRAINT constraint_name ]
28         { NOT NULL | NULL | UNIQUE | PRIMARY KEY |
29           CHECK (expression) |
30           REFERENCES reftable [ ( refcolumn ) ] [ MATCH FULL | MATCH PARTIAL ]
31             [ ON DELETE action ] [ ON UPDATE action ] }
32         [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]
33
34       and table_constraint is:
35
36         [ CONSTRAINT constraint_name ]
37         { UNIQUE ( column_name [, ... ] ) |
38           PRIMARY KEY ( column_name [, ... ] ) |
39           CHECK ( expression ) |
40           FOREIGN KEY ( column_name [, ... ] ) REFERENCES reftable [ ( refcolumn [, ... ] ) ]
41             [ MATCH FULL | MATCH PARTIAL ] [ ON DELETE action ] [ ON UPDATE action ] }
42         [ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]
43

Create Index Syntax

45         CREATE [ UNIQUE ] INDEX index_name ON table
46             [ USING acc_method ] ( column [ ops_name ] [, ...] )
47             [ WHERE predicate ]
48         CREATE [ UNIQUE ] INDEX index_name ON table
49             [ USING acc_method ] ( func_name( column [, ... ]) [ ops_name ] )
50             [ WHERE predicate ]
51

SEE ALSO

53       SQL::Translator.
54

AUTHORS

56       Sam Angiuoli <angiuoli@users.sourceforge.net>, Paul Harrington
57       <harringp@deshaw.com>, Ken Youens-Clark <kclark@cpan.org>.
58
59
60
61perl v5.12.0                      2009-08-1S8QL::Translator::Producer::Sybase(3)
Impressum