SQL Server: how to search for a table name or a column name or a given stored procedure name

This article demonstrates how the Microsoft SQL Server database can be queried to perform the following tasks:

1. fetch a list of tables.
2. fetch a list of Columns.
3. fetch a list of Stored Procedures

The results can refined further by including other search criteria in the where clause of each query.

--Query to fetch the list of table that match a pattern
select * from information_schema.tables where table_name like '%Employee%'

--Query to fetch the list of Columns (with table info) that match a pattern.
select * from information_schema.columns where column_name like '%EmpId%'

--Query to fetch the list of Stored Procedures that match a pattern.
select ROUTINE_SCHEMA, ROUTINE_NAME, ROUTINE_DEFINITION from INFORMATION_SCHEMA.ROUTINES
where ROUTINE_TYPE='PROCEDURE' and routine_name like '%MyProc%'

PS: Sql Authority is an excellent blog by Pinal Kumar Dev of SQL Server related info.

Reference:
[1] MSDN Online

DotNet Reference Poster

Thanks for still being in tune with my blog. It has been a while since my last post. I was in the midst of a change in Project/Client. I have for sure learnt a little bit in the last few months and will be updating my blog with my experiences soon. In the meanwhile here is something that is very nice to have for all Dotnet developers: The Dotnet 3.5 Reference poster [1]. This poster has a listing of commonly Used Types and Namespaces of .Net Framework 3.5

Note: I have borrowed this image from the blog titled “Fun with .Net and SQL Server” [2].

The .NET Framework 3.5 Common Namespaces and Types Poster is downloadable as XPS or PDF format. There is also an XPS format file which prints over 16 letter or A4 pages for easy printing. The following diagram [3] shows the additive nature of the .Net framework and clearly states the new features of each version.

Reference:

[1] MSDN online
[2] Fun with .NET and SQL Server
[3]Announcing: The .NET Framework 3.5 Commonly Used Types and Namespaces poster – Paul Andrew