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

Article View: borland.public.interbase.sql

Article #11042

Back to borland.public.interbase.sql Previous Next

#11042

From: 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."

Technical Details

Message-ID: <3dff2563@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newsfeed.news2me.com!opentransit.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <3dff2322@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 114a0e,f0ac75b988552c83
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2002-12-17 05:40:04 PST
From: "Martijn Tonies" <m.tonies@upscene_remove.com>
Newsgroups: borland.public.interbase.sql
References: <3dff2322@newsgroups.borland.com>
Subject: Re: adding "is null" to an existing column with stored data
Date: Tue, 17 Dec 2002 14:26:49 +0100
Lines: 32
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 212.238.179.102
Message-ID: <3dff2563@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1040131427 212.238.179.102 (17 Dec 2002 05:23:47 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newsfeed.news2me.com!opentransit.net!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message