Advertisement

07.01.2008 at 02:25PM PDT, ID: 23531761
[x]
Attachment Details

using system tables to find all tables containing a specific column

Asked by garyinmiami2003 in Databases Miscellaneous

Tags: , ,

I need to be able to query the system tables to find all tables containing a specific column name

Something like select * from sysobjects where column_name = 'column_name'


I don't think sysobjects is the correct system tableStart Free Trial
[+][-]07.01.2008 at 10:04PM PDT, ID: 21913606

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.02.2008 at 06:27AM PDT, ID: 21916104

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.02.2008 at 12:54PM PDT, ID: 21920053

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.02.2008 at 01:12PM PDT, ID: 21920229

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.02.2008 at 01:15PM PDT, ID: 21920248

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Databases Miscellaneous
Tags: sybase, sql, 15
Sign Up Now!
Solution Provided By: dportas
Participating Experts: 1
Solution Grade: A
 
 
[+][-]07.02.2008 at 01:18PM PDT, ID: 21920284

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628