Information Schema and SQL Server 2005
page 1 of 4
Published: 06 Sep 2007
This article provides some basic information about Information Schema in SQL Server 2005.
by Uday Denduluri
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 21624/ 64


Information Schema is the part of the SQL-92 standard which exposes the metadata of the database. In SQL server a set of views are created in each of the database which exposes the metadata of the database. The information schema is kept in a separate schema - information schema - which exists in all databases, but which is not included in the search path by default. It is implemented as a set of views returning specially defined data types as required by the standard. The access rights of these views do not fall under the login type "dbo." Using Information Schema we can get the information about tables, views, constraints, etc.

View Entire Article

User Comments

Title: Schema   
Name: Sankar
Date: 2008-08-29 5:57:45 AM
It's very useful... thanks lot....

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2024  |  Page Processed at 2024-06-24 10:29:19 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search