Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    9

    Unanswered: Which version does not support 'REFERENCES' privilege

    Hi friends,
    can anyone tell me from which version of SYBASE was the 'references' privilege supported.
    Thanks in advance.

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    ANSI-92, is it??

    References is supported on ASE 12 and 12.5

  3. #3
    Join Date
    Oct 2003
    Posts
    9

    not 11.5?

    Hi willy_and_the_ci,
    thanks for your valuable reply, I appreciate the promptness. Just one more thing, are you sure that references privilege is not supported on SYBASE 11.5?
    Pls let me know ASAP, I'll be really grateful!

  4. #4
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208

    Re: not 11.5?

    Originally posted by kos2003
    Hi willy_and_the_ci,
    thanks for your valuable reply, I appreciate the promptness. Just one more thing, are you sure that references privilege is not supported on SYBASE 11.5?
    Pls let me know ASAP, I'll be really grateful!
    YES!!!

    References was available and supported as part of SQL syntax in ASE 11.5.1 The below SQL works and is fro pubs3 database that came with ASE 11.5.1

    create table stores(stor_id char(4) notnull,
    stor_name varchar(40) null,
    stor_address varchar(40) null,
    city varchar(20) null,
    state char(2) null,
    country varchar(12) null,
    postalcode char(10) null,
    payterms varchar(12) null,
    unique nonclustered (stor_id))

    The second table, store_employees, is a "referencing table" because it contains a reference to the stores table. It also contains a self-reference:

    create table store_employees(stor_id char(4) null references stores(stor_id),emp_id id not null,
    mgr_id id null references store_employees(emp_id),
    emp_lname varchar(40) not null,
    emp_fname varchar(20) not null,
    phone char(12) null,
    address varchar(40) null,
    city varchar(20) null,
    state char(2) null,
    country varchar(12) null,
    postalcode varchar(10) null,
    unique nonclustered (emp_id))
    Last edited by willy_and_the_ci; 10-14-03 at 09:40.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •