P: Stored procedure, pK: Primary Key constraint, rF: Replication Filter stored procedure, s: System table.
For more information, please visit the following links: Compatibility Views (Transact-SQL px, mapping SQL Server 2000 System Tables to SQL Server 2005 System Views: px, user-Schema Separation: px, if you have any more questions, please feel free to let me know.
SQ Service queue, tA Assembly (CLR) DML trigger, tF Table function.
Spt_values, where type 'O9T aND number -1.Where Sys1.xtype'TR orderby TableName, in SQL Server 2005, the preferred technique is to use the system views.In SQL Server 2005, since many of new features are used and stored in the system database, so these two views (sysobjects and sys.Hi Manish, According to Books Online (BOL many of the system tables from earlier releases of SQL Server are now implemented as a set of views in SQL Server 2005.TR: Trigger, 3d truck simulator games for pc u: User table, uQ: Unique constraint, v: View, x: Extended stored procedure.The compatibility views expose the same metadata that was available in SQL Server 2000.However, you may need to do something unusual once in a while, such as list all the triggers in your database.However, the compatibility views do not expose any of the metadata related to features that are introduced in SQL Server 2005.Microsoft SQL Server 2008 Sys.These views are known as compatibility views, and they are meant for backward compatibility only.Spt_values where type 'O9T' AND number -1 select alien vs predator 2 primal hunt no cd AS xtype, right(name, (LEN(name) - patindex name) AS Description from master.
You could inspect your tables one by one, but that can become quite labor intensive if you have 500 tables.
Everything about your SQL Server database is stored in its system tables.