Re: Whats Informix thinking or Idea

ian wrote:

But I was really after the reasoning Informix or whoever used in
hiding these indexes?

I don't _know_ but I suspect it that it's because of a mismatch between SQL and the way Informix works underneath. In implementation terms primary keys require a unique index but standard SQL allows you to do things like:

create table foo (
bar varchar(100),
primary key (bar)
);

I guess the choice for the developers was either not to allow the standard SQL above and force explicit creation of a unique index before a primary key could be created, or allow the SQL above and create an index implicitly. Why then it's hidden is probably a design choice but I suspect people like to see the same SQL they used to create the table outputted by 'dbschema'.

Ben.
.

Relevant Pages

  • Re: Duplicating data in continuous subform linked to SQL
    ... tables to a SQL 2008 DB that was upsized with Access 2003 to SQL 2005 then ... have a primary key or that Access has some trouble finding it or using it; ... using this second unique index as the primary key. ... you should take a look with the SQL-Server Profiler to see ...
    (microsoft.public.access.adp.sqlserver)
  • Re: SQL Express - Identity specification property - how to change
    ... FOO_ID int identity, ... Tony Rogerson, SQL Server MVP ... They are making unfortunately frequent use of the IDENTITY column in conjunction with Primary Key. ... IDENTITY has none of the properties of a data type because it is not a data type at all. ...
    (comp.databases.ms-sqlserver)
  • Re: Binding and adding rows with SQL identity column
    ... Each time you call AddNew then the DataTable generates a new ... Each time an update is done then the real primary key ... > generated by the built-in wizard in VS2003. ... > identity column on the sql table, perhaps this would all the fine and I ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Re: What happens after 2^32 autonum keys are exhausted?
    ... Tony Rogerson, SQL Server MVP ... generated primary key despite the risk of a hardware or software error or a fault in the space-time continuum. ... identifier and have to invent one, follow the data design (data ...
    (comp.databases)
  • Re: sliced find in Linq
    ... by over all of the returned columns. ... Since the original query was unordered, I'd like the above SQL to ... (Perhaps your table doesn't have a primary key though?) ... didn't specify the ordering, so any ordering could have been used. ...
    (microsoft.public.dotnet.languages.csharp)
Loading