Sybase ASA中查询元信息的几个常用SQL函数
【-IT技术报道】Sybase ASA中查询元信息的几个常用SQL函数:
sp_column_privileges Unsupported
sp_columns table-name 返回指定列的数据类型
sp_databases Unsupported
sp_datatype_info Unsupported
sp_fkeys pktable_name 表的外键信息
sp_pkeys table-name 表的主键信息
sp_server_info Unsupported
sp_special_columns table_name 表的标识行的特定列的信息
sp_sproc_columns proc-name 存储过程的输入输出参数信息
sp_stored_procedures 一个或者多个存储过程信息
sp_statistics 表及其索引列的信息
sp_tables table-name 指定表的信息
例:
1.查询数据库jagdemo里有哪些表
sp_tables
current database,creator,tname,ifif SYSTABLE.table_type = "B,null
"jagdemo","SYS","SYSARTICLE","SYSTEM TABLE",
"jagdemo","SYS","SYSARTICLECOL","SYSTEM TABLE",
"jagdemo","DBA","account","TABLE",
"jagdemo","SYS","SYSREMOTEUSER","SYSTEM TABLE",
"jagdemo","SYS","SYSSUBSCRIPTION","SYSTEM TABLE",
"jagdemo","SYS","SYSUSERMESSAGES","SYSTEM TABLE",
"jagdemo","SYS","SYSUSERTYPE","SYSTEM TABLE",
"jagdemo","SYS","SYSEXTENT","SYSTEM TABLE",
"jagdemo","SYS","SYSREMOTETYPE","SYSTEM TABLE",
"jagdemo","SYS","SYSSQLSERVERTYPE","SYSTEM TABLE",
"jagdemo","SYS","SYSTYPEMAP","SYSTEM TABLE",
"jagdemo","SYS","SYSUSERLIST","VIEW",
"jagdemo","SYS","SYSCOLAUTH","VIEW",
"jagdemo","SYS","SYSINDEXES","VIEW",
"jagdemo","SYS","SYSUSERAUTH","VIEW",
2.查询表account的列信息
sp_columns account
jagdemo DBA account balance 7 real 7 4 0 10 0 59 2
jagdemo DBA account student_id 1 char 16 16 0 0
(责任编辑:卢兆林)
-
相关文章
2秒记住本站域名
玩过泡泡龙吗?Readygo?Go! 再加上.Com.Cn的后缀,那就是大名小顶的ReadyGo.com.cn
