Firebird SQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed Forums > Databases > Firebird SQL Development
Reload this Page

How to ALTER COLUMN?

Discuss How to ALTER COLUMN? in the Firebird SQL Development forum on Dev Shed.
How to ALTER COLUMN? Firebird SQL Development forum discussing administration, Firebird SQL syntax, or other Firebird SQL-related topics. Firebird is the evolution of Borland's Interbase product.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
  #1  
Old June 2nd, 2005, 05:15 AM
JGeer JGeer is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Jan 2005
Posts: 14 JGeer User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 5 h 9 m 57 sec
Reputation Power: 0
Question How to ALTER COLUMN?
Hi,

I'm getting the following error message when I excute this query:

ALTER TABLE CLIENTES ALTER COLUMN Observaciones TYPE VARCHAR(10000)

Error message:

unsuccessful metadata update.
Column OBSERVACIONES from table CLIENTES is referenced in U_CLIENTES

The column I'm trying to change it's a regular column (no index, no key)

How can I do it?

Thanks in advance,
JGeer
Reply With Quote
  #2  
Old June 2nd, 2005, 05:38 AM
pabloj's Avatar
pabloj pabloj is offline
Modding: Oracle MsSQL Firebird
Dev Shed God 6th Plane (7500 - 7999 posts)
  
Join Date: Jun 2001
Location: Outside US
Posts: 7,906 pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 2 Months 3 Weeks 3 Days 6 h 56 m 54 sec
Reputation Power: 279
Is there an FK pointing to that?
Reply With Quote
  #3  
Old June 2nd, 2005, 06:16 AM
fikret fikret is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Aug 2004
Location: Sarajevo, Bosnia
Posts: 111 fikret User rank is Corporal (100 - 500 Reputation Level)fikret User rank is Corporal (100 - 500 Reputation Level)fikret User rank is Corporal (100 - 500 Reputation Level)fikret User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 1 Day 5 h 32 m 11 sec
Reputation Power: 8
What is U_CLIENTES?


--
Best regards,
Fikret Hasovic http://fikret.fbtalk.net
USAID TAMP Senior Programmer
* FirebirdSQL Foundation member.
- Join today at http://www.firebirdsql.org/ff/foundation
* JEDI VCS contributor
http://jedivcs.sourceforge.net/
* Firebird and Fyracle news
http://www.fyracle.org
Reply With Quote
  #4  
Old June 2nd, 2005, 11:39 AM
JGeer JGeer is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Jan 2005
Posts: 14 JGeer User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 5 h 9 m 57 sec
Reputation Power: 0
U_Clientes is a stored procedure that updates the table Clientes.

No FK points to that field either.

Thanks.
Reply With Quote
  #5  
Old June 3rd, 2005, 02:11 AM
SilverDB's Avatar
SilverDB SilverDB is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Sep 2004
Location: Romania
Posts: 173 SilverDB User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 Day 45 m 53 sec
Reputation Power: 5
Send a message via Yahoo to SilverDB
All you have to do is comment the procedure's body (between begin and end ), alter the column and then uncomment the procedure.
__________________
If i've been helpful, please add to my reputation.
My unfinished site: http://www.dever.ro
Reply With Quote
  #6  
Old June 3rd, 2005, 03:45 AM
JGeer JGeer is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Jan 2005
Posts: 14 JGeer User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 5 h 9 m 57 sec
Reputation Power: 0
Thanks SilverDB, that solves the problem although I have a few procedures to comment

Is this the only method to solve the problem?

What if I want to alter a column from code? Is there any way to disable dependencies? Maybe through system tables?



Thanks again,
JGeer
Reply With Quote
Reply

Viewing: Dev Shed Forums > Databases > Firebird SQL Development > How to ALTER COLUMN?

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 2 hosted by Hostway. 
Stay green...Green IT