Mailing List Archive


Back to the month index Back to the list index
Giancarlo Russo (interf@interferenza.com)
Sun, 5 Jan 1997 17:07:36 +1 

Message-Id: <199701051615.IAA04223@shellx.best.com>
From: "Giancarlo Russo" <interf@interferenza.com>
Date: Sun, 5 Jan 1997 17:07:36 +1
Subject: [mSQL] Changes in table fields ?

Hi all
Sorry, other newbie questions for you.
I'm using mSQL v1.16

Can I add or remove a field (or column if you like) from a table,
without deleting and re-creating the whole thing ?

Can I change the field names and attributes (is not null, primary
key) without deleting and re-creating the whole table ?

I created a table with a 'is not null' field and I tryed to insert a
record with the null string '' for that field.
Why the insert operation was successful and I got back no error
messages ?

What will be the result if I mark two fields as 'primary key' ?
a) I won't be able to insert two or more records with _BOTH_ the
   two fields equal.
b) I won't be able to insert two or more records with _ONE_ of the
   two fields equal.

Thanks

-------------------------------------------------------
 Giancarlo Russo
 INTERFERENZA (net services, web & graphics design)
 web: http://www.interferenza.com
 e-mail: interf@interferenza.com
 tel: +39 823 492123 - cell: 0347 2453658
 home page: http://www.interferenza.com/personal/giangy
-------------------------------------------------------
--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!