SQL System Table Archives - Page 4 of 13 - SQL Authority with Pinal Dave

Interview Question of the Week #054 – Retrieve User Defined Object Details from sys.objects

January 17, 2016

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

Sometimes questions in the interview are extremely open ended and such questions can be very useful for candidate to play around with. For example, in one of the recent interview one of the interviewer asked the candidate that what is his favorite T-SQL script as a database administrator. The answer…

SQL SERVER – What is is_not_trusted in sys.foreign_keys?

January 9, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL System Table

My greatest source of learning is via my blog. Many of you take time in asking your toughest questions and sometimes basic questions that make me think. This interaction creates a source of exploration for me and ultimately translates into my knowledge sharing. All questions asked by DBAs are not…

MySQL – List User Defined Tables – Two Methods

April 1, 2014

Pinal Dave

SQL Tips and Tricks

MySQL, SQL Scripts, SQL Server, SQL System Table

There are different methods to list out user defined tables in MySQL. We will see two methods in this post.

Let us create the following tables in the database named Test

SQL SERVER – Finding Different ColumnName From Almost Identitical Tables

October 18, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL System Table

I have mentioned earlier on this blog that I love social media – Facebook and Twitter. I receive so many interesting questions that sometimes I wonder how come I never faced them in my real life scenario. Well, let us see one of the similar situation. Here is one of…

SQL SERVER – 2012 – List All The Column With Specific Data Types in Database

October 13, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL DMV, SQL System Table

5 years ago I wrote script SQL SERVER – 2005 – List All The Column With Specific Data Types, when I read it again, it is very much relevant and I liked it. This is one of the script which every developer would like to keep it handy. I have…

SQL SERVER – Validating Unique Column Name Across Whole Database

September 22, 2012

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL System Table

I sometimes come across very strange requirements and often I do not receive a proper explanation of the same. Here is the one of those examples. In this blog post we will discuss about how to validate unique column name across the whole database. The requirement was that column should not repeat the whole database.

SQL SERVER – INFORMATION_SCHEMA.COLUMNS and Value Character Maximum Length -1

July 20, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL System Table

I personally use the sys schema and DMV to retrieve most of the information. However, I am not surprised see usage of Information_Schema. It has been very popular and works in most of the time. Though, I do not use any feature it does not mean everybody else should stop…