title: Foreign Relationship Not view in key column
body: <p>I have database table server called like  TP_Users and TP_Roles</p>
  
  <pre><code> TP_Roles:
  
   Id         PK, int, not null
   Role_Name  varchar(200), null
   IsActive   bit, null
  
  
  TP_Users:
  
   Id          PK, int, not null
   UserName    nvarchar(50), null
   UserEmail   nvarchar(50), null
   DisplayName nvarchar(50), null
   Password    nvarchar(50), null
   RoleId      FK, int, not null
   IsActive    bit, not null
   ClientId    int, null
  </code></pre>
  
  <p>I have seen column FK_key value Foreign Key Server database </p>
  
  <pre><code>       FK Name                     Parent table       name      column_id       Refrenced table   name1  column_id1
  FK__Users_cop__RoleI__27AED5D5      TP_Users         RoleId        6               TP_Roles       Id         1
  
  FK__Users_cop__RoleI__28A2FA0E      TP_Users         RoleId        6               TP_Roles       Id         1
  </code></pre>
  
  <p>I want create like this Relationship using foreign key in local used like </p>
  
  <pre><code>CREATE TABLE TP_USERS (
    ID int(11) NOT NULL,
    USER_NAME varchar(50),
    ROL_ID int(11) NOT NULL,
    PRIMARY KEY (ID),
    CONSTRAINT `FK_roles` FOREIGN KEY (`ROL_ID`) REFERENCES `TP_ROLES` (`ID`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  </code></pre>
  
  <p>after that check view i can view only one Fk_name  value not  able to seen other one but  i can view two Fk_key name server database .  what is mistake i did ? please any one Guide me </p>