Information_schema Archives

SQL Server / SQL Server Accidental DBA Series

Find tables with identity columns in SQL Server

December 6, 2014December 20, 2019 - by SQL Geek - Leave a Comment

In this blog we’ll see T-SQL query to find tables with identity columns In SQL Server. It can be done in two ways either by using Information_schema catalog or the system …

SQL Server / SQL Server Accidental DBA Series

T-SQL script to find column in database

July 1, 2014December 23, 2019 - by SQL Geek - Leave a Comment

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()) …