Results 1 to 2 of 2

Thread: Can we set the primary key for item_master

  1. #1
    Junior Member
    Join Date
    Mar 2006
    Answers
    1

    Can we set the primary key for item_master

    If any body now plz ans me it's urgent

    One user name store and another user name ramesh in same database, I have table name Item_master in Store user where as child table in ramesh user, Can we set the primary key for in two diffrent user, item_master in store user and child table for frogein key in ramesh user? If yes How?

    Last edited by yusuf_sagari; 05-07-2007 at 06:50 AM.

  2. #2
    Contributing Member
    Join Date
    Apr 2007
    Answers
    46

    Re: Can we set the primary key for item_master

    i think u r asking whether we can create the primary key on the table and make it foreign for other.
    if this is case then yes u can make easily.

    alter table table1 add constraint constraint_name primary_key(columkn_name);

    alter table table1 add constarint constraint_name foreign_key(col_name) referenced by table2;

    pls check once syntax

    reeta


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact