Skip to content
February 7, 2023
  • Subscribe
  • Twitter
  • LinkedIN Group (Forum)
  • Facebook Group (Forum)
  • Facebook Page
  • YouTube
  • Telegram Group (Forum)
SQLServerGeeks

SQLServerGeeks

SQL Server Education (by the geeks, for the geeks)

Free Live Training Virtual Symposium DPD banglore
  • Blogs
    • Subscribe To Our Newsletter
    • SQLServerGeeks Bulletin Index
    • The Scripts Garage
    • All Blog Posts
    • One DMV a Day Series
    • Accidental DBA Series
    • One Operator a Day Series
    • One Trace Flag a Day Series
  • Magazine
  • Events
    • Browse Events
    • Suggest Topics
  • Videos
    • SSG Videos Lobby
    • SQL Server Tutorials & Demos
    • Webinar Recordings
    • SQLShighra Recordings
    • Virtual Symposium Recordings
      • SQL Server & Azure SQL – May 2021
      • SQL Server 2019 & Azure SQL – May 2020
    • Geek Talks
  • RESOURCES
    • SQL Server Resources
    • SQL Server Notes
  • Social
    • Subscribe To Our Newsletter
    • Twitter
    • LinkedIN Group (Forum)
    • Facebook Group
    • Facebook Page
    • YouTube Channel
    • Telegram Group (Forum)
  • About Us
    • Subscribe To Our Newsletter
    • SSG Team
    • Join Us
    • Speakers
    • Blog With Us
    • Contact Us
    • Write a Guest Post
    • Testimonials
    • Join DataPlatformGeeks community
  • Log In
  • Join Now
Main Menu

Tag: Sys.columns

SQL Server / SQL Server Accidental DBA Series

T-SQL find all identity columns

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

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 …

T-SQL find all identity columns Read More
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 …

Find tables with identity columns in SQL Server Read More
SQL Server / SQL Server Accidental DBA Series

SQL query to get row size in SQL Server

September 20, 2014December 23, 2019 - by SQL Geek - 1 Comment

Below 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 …

SQL query to get row size in SQL Server Read More
SQL Server / SQL Server Accidental DBA Series

SQL Query to find table size in SQL Server

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

Below 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 …

SQL Query to find table size in SQL Server Read More
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()) …

T-SQL script to find column in database Read More
SQL Server / SQL Server Accidental DBA Series

T-SQL find constraints on table

June 25, 2014December 23, 2019 - by SQL Geek - Leave a Comment

Many 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 …

T-SQL find constraints on table Read More
SQL Server

SQL Server: An Interesting way to get column related info – Part 2

July 13, 2011November 27, 2014 - by admin - 1 Comment

Hi 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
SQL Server

SQL Server: How to find column related detailed info for any table?

July 13, 2011July 5, 2014 - by admin - 3 Comments.

If 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 …

SQL Server: How to find column related detailed info for any table? Read More

Subscribe to SQLServerGeeks


Ad

Virtual Symposium

master classes



SSG_linkedin

SSG_fb

About Us

  • Core Team
  • Authors
  • Blog With Us
  • Testimonials
  • Contact Us
  • Join DataPlatformGeeks Community

Virtual Symposium

Copyright © 2022 SQLServerGeeks. Community initiative by Amit Bansal | Anti-Harassment Policy
Powered by WordPress and HitMag.