select * from pg_namespace
exec sp_stored_procedures '%'
exec sp_tables '%' ;
exec sp_stored_procedures '%'
exec sp_schemas '%' ;
select * from sysdatabases
select * from dbo.sysusers;
exec sp_stored_procedures '%', 'dbo', 'master'
select * from sysobjects where name='master'
select * from sysobjects where type='U'
sp_helptext sp_autoformat viewname or procname
select @@version
sp_helpdb
sp_helplogins
select * from sys.sql_modules;
select * from dqms.dbo.sysobjects where type='SF' or type='F' ;
select * from master.dbo.sysobjects where type='P';
select * from dqms.dbo.sysobjects where type='V';
select * from dqms.dbo.sysobjects where type='U'
select a.colid as id,b.name as tab_name,a.name as col_name,c.name as type,a.length as all_length,a.prec as length,a.scale,case isnull(a.status,0) when 0 then 'NOT NULL' ELSE 'NULL' END AS isnull
from syscolumns a,sysobjects b,systypes c
where a.id=b.id and a.usertype=c.usertype and b.name ='duty_report_tmp' ;
--查询数据库中用户表的名称
SELECT name FROM sysobjects WHERE type='U' order by name
--查询数据库中存储过程的名称
SELECT name FROM sysobjects WHERE type = 'P'
--查询数据库中函数的名称
SELECT name FROM sysobjects WHERE type='SF'
1.获得Sybase中所有数据库: select dbid,name from master..sysdatabases
2.获得指定数据库中的表列表:select name from 数据库..sysobjects where type='U' order by name
3.获得指定数据库中的视图列表:select name from 数据库..sysobjects where type='V' order by name
4.获得指定数据库中的存储过程列表:select name from 数据库..sysobjects where type='P' order by name
5.获得指定表&视图中字段或参数:SELECT a.name, b.name FROM syscolumns a LEFT JOIN systypes b ON a.usertype = b.usertype INNER JOIN sysobjects d ON a.id = d.id AND d.name <> 'dtproperties' LEFT JOIN syscomments e ON a.cdefault = e.id WHERE d.name = '表名&视图名&存储过程'