INFORMATION_SCHEMA.PARAMETERS

Is anybody able to access system tables used byINFORMATION_SCHEMA.PARAMETERS?

Namely:sys.sysscalartypes,sys.sysschobjs andsys.syscolpars.

A select on any of these failes with'Invalid object name'

[541 byte] By [boblotz2001] at [2007-12-24]
# 1

These are system base tables that are used by the database engine only.

Please see http://msdn2.microsoft.com/en-us/library/ms179503.aspx

Is there a reason why you would want to access these base tables ?

AsvinAnanthanarayanMSFT at 2007-10-8 > top of Msdn Tech,SQL Server,SQL Server Database Engine...
# 2
Curiosity really...
boblotz2001 at 2007-10-8 > top of Msdn Tech,SQL Server,SQL Server Database Engine...

SQL Server

Site Classified