Re: Sorting of a table on create

From: James Petts <jpetts_at_celltech.co.uk>
Date: 1998/01/08
Message-ID: <34B4CFA4.1156_at_celltech.co.uk>#1/1


Jeff wrote:

> Is there something I am doing wrong? What I am trying to do is create the
> table with a primary key (ref_nbr) sorted on the primary key.

One of the tenets of the relational model is that the rows are NOT sorted within a table. You will need to tell your RDBMS to sort the data when you select them, usually by using the ORDER BY clause.

-- 
James "I'd rather fall off Ilustrada than ride any other horse" Petts
Received on Thu Jan 08 1998 - 00:00:00 CET

Original text of this message