SQL Server Education (by the geeks, for the geeks)
Here’s a T-SQL find all identity columns in a database. SELECT OBJECT_SCHEMA_NAME(tables.object_id, db_id()) AS SchemaName, tables.name As TableName, columns.name as ColumnName FROM sys.tables tables JOIN sys.columns columns ON tables.object_id=columns.object_id WHERE columns.is_identity=1 …
Read MoreIn 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 …
Read MoreBelow is a SQL query to find row size. The query uses DATALENGTH function, which returns the number of bytes used to represent a column data. A row may consist of …
Read MoreBelow is a SQL query to find table size in SQL Server. The calculation is based on SQL Query to find row size SQL Server blog (give the link of the …
Read MoreMany 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 MoreMany a times need arises to find all constraints on a table. A common use case is when dropping columns from a table we need to know the dependent objects so …
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 MoreIf i ask you to get me a list of all the columns in 25 tables those are being replicated or being used by certain application module, how will you get …
Read More