Monday, September 13, 2010

Find the column name of the given SMS table or view

select column_name,table_name from information_schema.columns
where table_name like '%' and column_name like '%serialnumber%' order by column_name

Description:

Many times , your client might have requested you to generate some adhoc reports from SMS Server. Sometimes we may not have information about the tables\views that contains the requested data. For example, if you do not know where is the information stored about serial number of SMS client machines, you can have a quick check by running above query. It lists out all the tables\views which contains the specified column name and easily you can reach out what you need!

1 Comments:

Anonymous Ajeesha said...

Hi Jaison. This is wonderful!. This will help me a lot. Thanks in advance.

September 14, 2010 at 2:43 AM  

Post a Comment

Subscribe to Post Comments [Atom]

Links to this post:

Create a Link

<< Home