><FONT color=#f70909>关键字 <a href="http://hackbase.com/hacker" target="_blank" >数据库</A> 对象
>SQL SERVER
>或者</P>% [' ~& m* d/ j- S7 Y$ X. w- t- ]
>USE master</P>) |: O9 [; F j$ J3 V0 J
>SELECT sysdb.name AS dbname, xlogin.name AS owner FROM sysdatabases AS sysdb LEFT JOIN sysxlogins AS xlogin ON sysdb.sid = xlogin.sid</P>; N* R: k- _- h! J/ b
>6 s1 L& k4 r0 c& J i; j m( M( ]
>取得表的方法3 o* x* }. [8 G0 B
>USE xxx</P>
>EXEC sp<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>help</P>
>或者</P>! ^; t% M9 R# |" J
>获取指定<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>的用户表:</P>
>USE DBAudit
>获取指定<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>的系统表:</P>
>USE DBAudit
>或者统一使用:</P>& [3 u3 n7 \, d3 ?
>USE DBAudit</P>
>SELECT sysobjects.name AS name, sysusers.name AS owner, type, sysobjects.id AS id FROM sysobjects LEFT JOIN sysusers ON sysobjects.uid = sysusers.uid WHERE type = 'U' OR type = 'S'</P>+ b! ?9 Y# l& g+ e+ T
>注:</P>8 v% l( c' g1 k3 M/ {
>sysobjects中type字段类型解释:</P>
>C = CHECK 约束</P>; F3 C1 V6 p# L- [2 |6 W# g
>D = 默认值或 DEFAULT 约束</P>
>F = FOREIGN KEY 约束</P>2 o! B; l- M2 I5 r6 \) ~! \& p
>L = 日志</P>) C$ z X6 ~3 e1 ]3 ]: N8 X
>FN = 标量函数</P>5 W# |. ]! ^) A2 f8 w3 U
>IF = 内嵌表函数</P>
>
= 存储过程</P>/ m7 ^/ o4 R7 \" s
>
K = PRIMARY KEY 约束(类型是 K)</P>! @# O9 D5 t+ r2 r, I! P2 I
>RF = 复制筛选存储过程</P>| 欢迎光临 数学建模社区-数学中国 (http://www.madio.net/) | Powered by Discuz! X2.5 |