sys_objects 2

[dmando84]

Hello,

I am searching for a specific column name in a database. I am unsure what the syntax is. This is what I have so far, but it is returning an error...

select * from sys_objects where col_name = 'ProductID'

Does anyone know the correct syntax? Any help would be appreciated.

Thank you,
Dave

 

[ptheriault]

These will work for you.

--gets all tables with "program" in the name
SELECT Name
FROM sysobjects
WHERE xtype ='u' --filter to table system objects
AND name LIKE '%program%'


--gets all columns and tables
SELECT SC.Name AS ColumnName
,SO.Name AS TableName
FROM syscolumns SC
JOIN sysObjects SO
ON SC.ID = SO.ID
WHERE SC.name LIKE '%'

- Paul
- Database performance looks fine, it must be the Network!

 

[SQLDenis]

Or by using ANSI views

select * from information_schema.columns where column_name = 'ProductID'


Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/