adding "is null" to an existing column with stored data

Thread View: borland.public.interbase.sql

4 messages

[T] Back to Threads [V] Tree View [G] Group Articles

4 total messages Started by Jack Tue, 17 Dec 2002 13:20

#11040

Author: Jack
Date: Tue, 17 Dec 2002 13:20

6 lines
1057 bytes

Hello,

Is it possible in IB 6 to add PRIMARY KEY NOT NULL constraints to an
existing column (numeric) with data already stored in?

For your help thanx in advance

Re: adding "is null" to an existing column with stored data

#11042

Author: Martijn Tonies
Date: Tue, 17 Dec 2002 13:26

30 lines
1802 bytes

Hi Jack,

The NOT NULL attribute is something different - yes, you can add it, but
only by directly editting the system tables.

A PRIMARY KEY constraint can be added via an ALTER TABLE
statement.

If you want a nice GUI tool do to both, check www.upscene.com and
download a copy of InterBase Workbench.

> Is it possible in IB 6 to add PRIMARY KEY NOT NULL constraints to an
> existing column (numeric) with data already stored in?
>
> For your help thanx in advance



--

With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

Re: adding "is null" to an existing column with stored data

#11041

Author: Robert Schieck
Date: Tue, 17 Dec 2002 13:39

18 lines
1622 bytes

In article <3dff2322@newsgroups.borland.com>, Jack wrote:
> Is it possible in IB 6 to add PRIMARY KEY NOT NULL constraints to an
> existing column (numeric) with data already stored in?
> 
> For your help thanx in advance
>

Interesting... 

Why not just add a unique index to the column... I use them in place of 
Primary keys all the time. They will allow one null though...

hth

Robert Schieck (TeamB)
MER Systems Inc.
Inprise/Borland/InterBase Search Engine 
http://www.mers.com/searchsite.html

Re: adding "is null" to an existing column with stored data

#11043

Author: Jack
Date: Tue, 17 Dec 2002 14:56

1 lines
1115 bytes

Thank you for your help guys! The IB Workbench seems to be very good.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads