system tables 
Author Message
 system tables

Does anybody know of any good sources that go into detail on SQL
Server system tables.  I have never seen a good write-up on
them(espically what the values in the fields mean).

Thanks,
Mike Adams



Fri, 05 Nov 1999 03:00:00 GMT
 system tables

Quote:

> Does anybody know of any good sources that go into detail on SQL
> Server system tables.  I have never seen a good write-up on
> them(espically what the values in the fields mean).

> Thanks,
> Mike Adams

It's covered in the Books Online under
Transact SQL Reference 6.0/S/System Tables .

Also be sure to look at What's New for SQL 6.5 . There were some
changes/additions.

Also, the source for the system stored procedures is a good place to
find out what valeus mean - particularly bit fields. You'll find the
source in syscomments in the master database.

______________________________________________________________________________
David Bratton
University of Houston System                    THE BILL OF RIGHTS



Mon, 08 Nov 1999 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. CREATE TABLE or Import results in new table being flagged as SYSTEM table

2. Hidding System Tables and System Stored Procedures in the MMC

3. How to hide system tables and system stored procedure from Enterprise management right panel

4. Passwords for paradox5 ;- system table {2/2} - system.db (1/1)

5. Dropping all tables from a SQL Database besides the system tables

6. System tables vs. user tables

7. system tables - link SP name and Table Name?

8. how to retrieve table PK in system table??

9. configuring sql server to not display system tables in the tables view

10. create system table instead of user table

11. SQL Server thinks User Table is System Table

12. System Tables - Retrieving Table and Column Descriptions


 
Powered by phpBB® Forum Software