New column not recognized

gayatridev@gmail.com · *nix forums beginner Joined: 04 Jul 2006 Posts: 2

Hi,

I am new to Sybase.

Here is my problem:

I added a new column to a table . I did this by truncating the
table,dropping it and creating the table with the new column .This
tabele belongs to say B DB.

when I do a sp_help on this table it wont show up the new columns.

Alos I am accessing the table from a stored -procedure from A DB .The
stored procedure also throws up "invalid column name error"

I dont know what is wrong .

Please help!

Thanks
Gayatri

Rob Verschoor · *nix forums addict Joined: 19 May 2005 Posts: 75

I'm pretty sure sp_help will show the new column. Can you post an example of
the dialog , showing sp_help not doing this?
For your own procs referring to this table, you'll need to drop & recreate
the procedure for the new column to be picked up. THis is expected and
documented behaviour BTW.

HTH,

Rob V.
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5 / TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase Replication Server Quick Reference Guide"
"The Complete Sybase ASE Quick Reference Guide"

mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

<gayatridev@gmail.com> wrote in message
news:1151988318.001618.23790@75g2000cwc.googlegroups.com...

gayatridev@gmail.com · *nix forums beginner Joined: 04 Jul 2006 Posts: 2

Google