Sybase iq数据库管理

2019独角兽企业重金招聘Python工程师标准>>>

/*解除锁表*/
sp_iqlocks
drop connection 22554

select name from sysobjects where type='S' and name like 'fun%' --选择出所有以fun开头的函数
/*SYBASE IQ管理命令*/
SELECT dbf.dbfile_name, f.*
FROM SYSFILE f, SYSDBFILE dbf
WHERE f.file_id=dbf.dbfile_id
sp_iqdbspace user_space
select 'rename' as 'restore ... rename' ,
dbf.dbfile_name as 'IQ file' , 'to' as 'to' ,
'''' + f.file_name + '''' as 'file_path'
from SYSFILE f, SYSDBFILE dbf
where f.store_type=2 and f.file_id=dbf.dbfile_id
select * from  SYSFILE
sp_iqcheckdb
SELECT connection_property('DBA')
SELECT * FROM SYS.SYSTAB
SELECT * FROM isystab
sp_helptext db_property;

转载于:https://my.oschina.net/u/1866459/blog/522779