n********6 发帖数: 1511 | |
c*****d 发帖数: 6045 | 2 sysobjects
【在 n********6 的大作中提到】 : Thank you very much.
|
a*******t 发帖数: 891 | 3 database level query
select *
from sys.sysobjects
where xtype = 'p' or xtype = 'tf'
and here is the xtype info from BOL
xtype
char(2)
Object type. Can be one of the following object types:
C = CHECK constraint
D = Default or DEFAULT constraint
F = FOREIGN KEY constraint
L = Log
FN = Scalar function
IF = In-lined table-function
P = Stored procedure
PK = PRIMARY KEY constraint (type is K)
RF = Replication filter stored procedure
S = System table
TF = Table function
TR = Trigger
U = User table
UQ =
【在 n********6 的大作中提到】 : Thank you very much.
|
n********6 发帖数: 1511 | 4 谢谢万能的coolbid和Assailant。sysobjects很好用。
我发现query out比programmability\stored procedures多了几个sp(e.g. name = sp_
alterdiagram)
又发现在programmability\stored procedures\system stored procedures里面(e.g.
name = dbo.sp_alterdiagram)
这些sp(e.g. dbo.sp_alterdiagram)是否user created?
如果是,怎么会在system stored procedure底下?dbo.是由什么决定的? |
n********6 发帖数: 1511 | 5 谢谢万能的coolbid和Assailant。sysobjects很好用。
我发现query out比programmability\stored procedures多了几个sp(e.g. name = sp_
alterdiagram)
又发现在programmability\stored procedures\system stored procedures里面(e.g.
name = dbo.sp_alterdiagram)
这些sp(e.g. dbo.sp_alterdiagram)是否user created?
如果是,怎么会在system stored procedure底下?dbo.是由什么决定的? |
j*****n 发帖数: 1781 | 6 read "schema" in BOL.
sp_
g.
【在 n********6 的大作中提到】 : 谢谢万能的coolbid和Assailant。sysobjects很好用。 : 我发现query out比programmability\stored procedures多了几个sp(e.g. name = sp_ : alterdiagram) : 又发现在programmability\stored procedures\system stored procedures里面(e.g. : name = dbo.sp_alterdiagram) : 这些sp(e.g. dbo.sp_alterdiagram)是否user created? : 如果是,怎么会在system stored procedure底下?dbo.是由什么决定的?
|