><FONT color=#f70909>关键字 <a href="http://hackbase.com/hacker" target="_blank" >数据库</A> 对象# f" K& C; M5 l6 S7 F5 R' C* B3 y" H
>SQL SERVER
>或者</P>0 e1 q( h" O+ g9 F. p# g2 {9 ~
>USE master</P>% T" J, s8 b* q' F; B
>SELECT sysdb.name AS dbname, xlogin.name AS owner FROM sysdatabases AS sysdb LEFT JOIN sysxlogins AS xlogin ON sysdb.sid = xlogin.sid</P>. ^; k# `$ [6 F2 x" q2 u# L: _9 {
>
>取得表的方法
>USE xxx</P>
>EXEC sp<a href="http://hackbase.com/hacker/tutorial/200502019779.htm#" target="_blank" >_</A>help</P>; B7 G [) U- I" i5 Q( o5 e
>或者</P>
>获取指定<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>的用户表:</P>
>USE DBAudit
>获取指定<a href="http://hackbase.com/hacker" target="_blank" >数据库</A>的系统表:</P>" Z$ [$ e. Q) i/ o; a7 P
>USE DBAudit
>或者统一使用:</P>
>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>
>注:</P>/ ~; N ^: ~ B4 @
>sysobjects中type字段类型解释:</P>0 v! Z; `+ M! H, C; S! d9 S
>C = CHECK 约束</P>
>D = 默认值或 DEFAULT 约束</P>( r( n5 g) H) B1 a
>F = FOREIGN KEY 约束</P>
>L = 日志</P>
>FN = 标量函数</P>
>IF = 内嵌表函数</P>
>
= 存储过程</P>
>
K = PRIMARY KEY 约束(类型是 K)</P>- Y0 z, M3 q; `* z
>RF = 复制筛选存储过程</P>2 P( r5 T" e% g3 e0 W" D. ~| 欢迎光临 数学建模社区-数学中国 (http://www.madio.net/) | Powered by Discuz! X2.5 |