SQL Server Sysobjects Types

MS SQL Server stores the information about the objects (tables, views, functions, etc) stored in the database in a table, which is accessible by selecting from the sysobjects view (sql2000) or the sys.objects and sys.sysobjects views (sql2005, sql2008).

The type of object is given by the columns xtype or type, depending on the view.

Documenting SQL Server Tables and Columns

Both SQL Server 2000 and 2005 feature a ‘Generate Scripts’ function, which lets you create the DDL statements to generate the CREATE TABLE statements of your database.

While this functionality is quite useful, it does not provide all the available information at one glance. For example, DEFAULT constraint definitions and Foreign Key definitions are separated from the Create Table statement as Alter Table statements further down the text.

Minimalistic Word Processing

If you think that your current word processing application is too bloated, too feature-laden, too distracting from the actual task of creating text, why not try some alternatives:

Initializing HoverMenuExtender and CollapsiblePanelExtender

A few tips on how to avoid screen flicker during page load when working with HoverMenu and CollapsiblePanel