identifying a system table

Posted Date: 09 Jun 2008	Resource Type: Tips	Category: General
Author: Payal Jain	Member Level: Gold
Rating:	Points: 3

The most common means of identifying a system table is by its name. All system tables start with the three characters sys, but not everything that starts with sys is a system table. Another way to identify system tables is by object ID; all system tables have an ID number less than 100. You can also identify system tables by looking at the type column in the sysobjects table; system tables have the type S

Responses

Author: Arunkumar 11 Jun 2008

Member Level: Silver Points : 2

Today morning I was search my system one table missing.At that time i use google search engine.but i can't find out.now i read this article you give a useful information for me. Thank You

Feedbacks

Popular Tags

What are tags ?

Search Tags

(No tags found.)

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Coding Standard & Code Review Points [Dot Net]
	Previous Resource: Very Important for PC Users
	Return to Discussion Resource Index
	Post New Resource
	Category: General

Post resources and earn money!

More Resources