Database views

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: CM (CM_at_discussions.microsoft.com)
Date: 09/23/04

  • Next message: Stefan Wuebbe: "Re: Database views" 
    Date: Thu, 23 Sep 2004 15:51:02 -0700

    I built my database with four tables linked via inner joins. Each table has
    a primary key associated with it. When I build a view using fields from all
    four tables, can I use the INDEX command on the view? Can I open another
    database view, index it and SET RELATION to the first one based on this index?

    Thank you very much,

    CM

  • Next message: Stefan Wuebbe: "Re: Database views"

    Relevant Pages

    • Re: Database views
      ... >I built my database with four tables linked via inner joins. ... > a primary key associated with it. ... > database view, index it and SET RELATION to the first one based on this index? ...
      (microsoft.public.fox.vfp.dbc)
    • Primary Key - moving through database
      ... I have built a database using social security # as the primary key. ...
      (microsoft.public.access.tablesdbdesign)
    • Re: Database views
      ... Why might the SET RELATION not be as reliable? ... >>I built my database with four tables linked via inner joins. ... >> database view, index it and SET RELATION to the first one based on this index? ...
      (microsoft.public.fox.vfp.dbc)
    • Re: problem using identity column as primary key
      ... >> I am thinking of creating an identity column to use it as primary key ... More and more programmers who have absolutely no database training are ... the gap in the sequence is not filled in and the sequence ... vin CHARNOT NULL REFERENCES Motorpool); ...
      (microsoft.public.sqlserver.programming)
    • Re: Updating the SQL key value
      ... before creating the database, by the time I've come to pick a primary key, ... articles, each of which must be issued under a particular licence (e.g. ... GPL GNU General Public Licence http://www.gnu ... ...
      (comp.lang.php)