a*t
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 的大作中提到】![](/moin_static193/solenoid/img/up.png)
: Thank you very much.
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 的大作中提到】
![](/moin_static193/solenoid/img/up.png)
: Thank you very much.
n*6
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.是由什么决定的?
我发现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
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.是由什么决定的?
我发现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
6 楼
read "schema" in BOL.
sp_
g.
【在 n********6 的大作中提到】![](/moin_static193/solenoid/img/up.png)
: 谢谢万能的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.是由什么决定的?
sp_
g.
【在 n********6 的大作中提到】
![](/moin_static193/solenoid/img/up.png)
: 谢谢万能的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.是由什么决定的?
相关阅读
Re: 5how to get the result in the middle of resultset?How to use the SQL key word EXISTS?Re: SQL crash, HELP!!请教一个问题Problem running MySql under Solaris 8Re: help: question on oracle sys_context(). more confused :(what is the size limitation of Oracle JDBC Statement?where to find Oracle adm's handbook, developer guide BOOK?help: question on oracle sys_context()How to delete Oracle SID?who knows a good data mining software free求教一ORACLE问题Re: HELP!! How to run SQL Server 7 in my local computer(Windows2000)?Re: Use Access Link table to h use SQL server tables.MS SQL server or PostgreSQL server?HELP: Oracle ENTERPRISE Manager Configuration Assistant is MissingProblems to define database object in Access2000Problems on ACCESS + VBAutomatically refresh??