SQL questions

From: Barry Roomberg <barry.roomberg_at_compudata.com>
Date: Tue, 13 Sep 94 17:06:00 -0500
Message-ID: <12a.4832.905_at_compudata.com>


-> 1. what is the maximum number of allowed columns per
-> table. I am trying to talk the application
-> developer out of a table with 6200+ columns and
-> would be grateful if someone could provide me
-> with a reference.

256.

->
-> 2. when creating a non-unique index on a table for a
-> column which is either null or some value, will
-> index entries be created for the rows whose
-> indexed column value is null?

No. Received on Wed Sep 14 1994 - 00:06:00 CEST

Original text of this message