Interpretation:
sysobjects system object table. Save the objects of the current database.
Such as constraints, defaults, logs, rules, stored procedures, etc
In sqlserver2005 and sqlserver2008 versions of the database, it is now a view object, and there is a sys.sysobjects view object in the system view of each database.
sysobjects important fields explained:
sysObjects (
Name sysname, --object name
id int, --object id
xtype char(2), -- object type
type char(2), -- Object type (seems to be exactly the same as xtype?) A little depressed... ）
uid smallint, -- the ID of the object owner
... --other fields are not commonly used.
)
Note: It needs to be explained that xtype and type are exactly the same, and his data is:
C = CHECK constraint
D = DEFAULT or DEFAULT constraint
F = FOREIGN KEY constraint
FN = scalar function
IF = Inline Table Function
K = PRIMARY KEY or UNIQUE constraints
L = log
P = stored procedure
R = rule
RF = Replication Filter Stored Procedure
S = System table
TF = table function
TR = Trigger
U = User Table
V = view
X = Extended stored procedure
AF = Aggregation Function (CLR)
FS = Assembly (CLR) scalar function
FT = assembly (CLR) table value function
IF = Inline Table Function
IT = Internal Table
PC = Assembly (CLR) stored procedure
PK = PRIMARY KEY constraint (type K)
SN = synonyms
SQ = Service Queue
TA = Assembly (CLR) DML Trigger
TT = table type
UQ = UNIQUE constraint (type is K)
The table contains all the objects in the database, such as those stored procedure views
|
Posted on 4/21/2017 11:17:01 AM
|
|
|
|
Posted on 5/30/2017 6:12:50 AM