Information Schema and SQL Server 2005
page 4 of 4
by Uday Denduluri
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 22867/ 58


The functionality of the Information_Schema is often confused with sysobjects, for example "select * from sysobjects where type = 'U.'" But, there are many differences between Information_Schema and sysobjects. Sysobjects are not the part of the SQL-92 standard and cannot be relied upon using Information_Schema views displays tables on which the user has permissions.

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-2021  |  Page Processed at 2021-11-26 10:11:55 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search