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()) …
T-SQL script to find column in database 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 …
How to find all available System and User Defined Data Types in SQL Server? 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, …
SQL Server: An Interesting way to get column related info – Part 2 Read More