Sybase DC38133-01-0902-01 manual Create Publication statement, Subscribe by expression

Models: DC38133-01-0902-01

1 485
Download 485 pages 33.95 Kb
Page 374
Image 374

CREATE PUBLICATION statement

Function

Use this statement to create a publication. In SQL Remote, publications

 

identify replicated data in both consolidated and remote databases.

Syntax

CREATE PUBLICATION [ owner.]publication-name

 

( TABLE article-description, . . . )

 

owner , publication-name :identifier

 

article-description:

 

table-name [ ( column-name, . . .) ]

 

[ WHERE search-condition ]

 

[ SUBSCRIBE BY expression ]

See also

“CREATE PUBLICATION statement” [ASA SQL Reference, page 385]

356

Page 374
Image 374
Sybase DC38133-01-0902-01 manual Create Publication statement ASA SQL Reference, Subscribe by expression