SQL Server Education (by the geeks, for the geeks)
Many a times we need to find all tables having a particular column in a database. Here is a T-SQL script to find column in database. SELECT DB_NAME(DB_ID()) As DatabaseName, OBJECT_SCHEMA_NAME(objects.object_id,db_id()) …
Read MoreHi Friends, If you ever want to get a list of all System and User defined Data Types info which are available in your SQL Environment you can use this Catalog …
Read MoreHi Friends, Yesterday I published one article “How to find column related detailed info for any table?” In that article i talked about an interesting way to get column related info, …
Read More