SQL Server: Find tables containing column name

Posted by kievia

To find all the user tables that contain a particular column name run the following command on the relevant database:

SELECT name FROM sysobjects WHERE xtype='U' and id IN( SELECT id FROM syscolumns

WHERE name like '%COLUMN NAME%' )

About kievia

Christian, Geek, Youth Worker, Bookworm

Posted on July 20, 2010, in IT and tagged sql server. Bookmark the permalink. Leave a Comment.

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Not published)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Connecting to %s