INFORMATION SCHEMA VIEWS in SQL Server

Who is online?  99 guests and 0 members
home  »  blogs  »  Did You Know Did You Know  »  INFORMATION SCHEMA VIEWS in SQL Server

Training on Microsoft Products & Technologies

INFORMATION SCHEMA VIEWS in SQL Server

change text size: A A A

posted  9/30/2011 5:39:45 PM  by Did You Know Did You Know -  Views: [874] 

Did you know that INFORMATION SCHEMA VIEWS are one of many ways in which you can view SQL Server metadata.

INFORMATION SCHEMA VIEWS are included in SQL Server to comply with ISO & ANSI standards. All views are under INFORMATION_SCHEMA schema. For example, if you want to see all the tables in your database, you run the following script:

select * from INFORMATION_SCHEMA.TABLES


Other ways of browsing meta data are catalog views, compatibility views, etc.

Regards
Did-You-Know from SQLServerGeeks.com 

tags : INFORMATION SCHEMA VIEWS, Metadata in SQL Server
  Rate This Blog Entry:  register  or  login

Author

Did-You-Know Did You Know Did You Know (Member since: 7/22/2011 4:47:27 PM)

View Did You Know Did You Know 's profile

Comments (1)

Gaurav Yadav
12/22/2011 3:16:33 PM Gaurav Yadav said:

This is one of the best articles so far I have read online. No crap, just useful information. Very well presented. Its really helpful for beginner as well as developer check out this link too its also helped me to complete my task.

Link

Thanks!!

by

Leave a comment

Name:
  *  
Email:  (your email is kept secure)
 *  
Website:

example: "http://www.SQLServerGeeks.com"

 
Type the characters:
 *
 
   

Training on Microsoft Products & Technologies

Training on Microsoft Products & Technologies

Email Subscriptions

   Get the Most Recent Blogs in your inbox
Blogs RSS Feed

Did You Know Did You Know's latest blog posts

Blogs RSS Feed

Latest community blog posts

  • SQL Server Day in Gurgaon in May 05’ 2012
    4/30/2012 5:05:54 AM by Admin Admin  - Views: 280  - Comments: 0
    Dear SQL Geek, SQLServerGeeks.com cordially invites you to SQL Server Day, the monthly dose of SQL Server knowledge & learning. And after successful events in Bangalore, Kolkata & Mumbai, we a...
  • SQL Server 2012 Feature Pack
    4/23/2012 9:24:41 AM by Quick Tip  - Views: 241  - Comments: 0
    Hi SQL Geeks, The Microsoft® SQL Server® 2012 Feature Pack is a collection of stand-alone packages which provide additional value for Microsoft® SQL Server® 2012. You can download the ...
  • SQL Server QUOTENAME function
    4/23/2012 9:09:51 AM by Amit Bansal  - Views: 1158  - Comments: 4
    Hi Friends, Here is an interesting function: QUOTENAME() which returns a Unicode string with the delimiters added to make the input string a valid SQL Server delimited identifier. (from Books Online) ...
  • SQL Server 2008 R2 Express Database size limit
    4/12/2012 8:20:10 AM by Ravi Kumar  - Views: 926  - Comments: 0
    Hi All, It is a great news to all those who use SQL Server Express editions. Microsoft has increased the database size limit of SQL Server 2008 R2 Express edition from 4GB to 10GB. Previous versions o...
  • SQL Server – What is Scalar Function?
    4/11/2012 7:04:48 AM by Piyush Bajaj  - Views: 3239  - Comments: 2
    Hello Friends, It’s been a while that I have posted any blog. So here it is- Well with the arrival of SQL Server 2000, Microsoft has introduced the concept of User Defined Function (UDF). So the...
  • SQL Server 2012 Released to Manufacturing
    4/9/2012 11:41:31 AM by SQLnews SQLnews  - Views: 325  - Comments: 0
    Exciting news! SQL Server 2012 has released to manufacturing. Customers and partners can download an evaluation of the product today and can expect general availability to begin on April 1. Microsoft ...