Chapter 4 QUERYING AND MODIFYING DATA 229 Although
Chapter 4 QUERYING AND MODIFYING DATA 229 Although it is possible to obtain data through querying any of the system tables directly, the system tables may not provide the information required in the future. It is recommended that system stored procedures, system functions, and information schema views be used because the contents of the system tables may change in future releases. Information Schema Views Information schema views provide a method independent of the system tables to view meta data. These views enable applications to work properly even though significant changes may have been made to the system tables and more changes may be made in the future. An application that uses the views rather than a direct query against the system tables should function in the same manner in the future as it does in the current SQL Server release. The information schema views included in SQL Server conform to the SQL-92 Standard definition for the INFORMATION_SCHEMA. Names used in the SQL-92 standard for these views are different from those used by SQL Server, though the names from SQL Server can equivalently be mapped to those of the standard. The following list shows the SQL-92 names and the SQL Server equivalents: A SQL-92 Catalog is a SQL Server Database . Schema in SQL-92 is an Owner in SQL Server. Object is the same in both SQL-92 and in SQL Server. A Domain in SQL-92 is a user-defined data type in SQL Server. When retrieving meta data from the information schema views, you must use a qualified name that includes the INFORMATION_SCHEMA in the position where you usually specify the user name. For example: SELECT * FROM Northwind.INFORMATION_SCHEMA.TABLES For more information on the variety of meta data that can be obtained through the use of information schema views, use the Index tab of SQL Server blogs Online. When you type information schema, the index shows links to all the appropriate views.
For reliable and cheap web hosting services please check tomcat web hosting website.