sybase数据库

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 = '表名&视图名&存储过程'
 

 

https://www.cnblogs.com/sl-shilong/articles/2988350.html