Looking for a particular column name in one of your tables in your SQL Server database, but it does not find here. This can be a time consuming job if you do not know the following trick. In SQL Server 2005 lacks a search function to quickly find a column in databases. This can sometimes still be useful if you are looking for a particular column but do not know what table this is. The solution is a relatively simple query. O. NAME Tabelnaam, SELECT O. NAME Table Name, Kolomnaam C. NAME Column Name sys. columns C FROM sys. Columns C sys. objects O ON C. OBJECT_ID = O. OBJECT_ID INNER JOIN sys. Objects O ON C. OBJECT_ID = O. OBJECT_ID C. NAME LIKE '%DebiteurNaam%' C. WHERE NAME LIKE '%% Customer Name " O. NAME , ORDER BY O. NAME, C. NAME
Result
Obviously it is not very useful for every time you examine this entire column in typing queries, so there is the following Stored Procedure, the task very straightforward process:
[ dbo ] . [ pcdGetColumns ] CREATE PROCEDURE [dbo]. [PcdGetColumns] ( 256 ) @ Column name nvarchar (256) - Search for a column name in a database - EXECUTE pcdGetColumns'% name% " AS BEGIN O. NAME Tabelnaam, SELECT O. NAME Table Name, Kolomnaam C. NAME Column Name sys. columns C FROM sys. Columns C sys. objects O ON C. OBJECT_ID = O. OBJECT_ID INNER JOIN sys. Objects O ON C. OBJECT_ID = O. OBJECT_ID C. NAME LIKE @kolomnaam WHERE C. NAME LIKE @ Column name O. NAME , C. NAME ORDER BY O. NAME, C. NAME END
Tags 
