Sybase - La FAQConsultez toutes les FAQ

1
2
  
SELECT name FROM sysobjects WHERE type='U'

1
2
  
SP_HELP 'MA_TABLE'

1
2
3
4
5
6
7
8
9
10
  
SELECT c.colid, c.name Colonne, 
       t.name Type, 
       Convert(varchar(10), c.prec ) + 
           CASE WHEN c.scale > 0 THEN ',' + Convert(varchar(10), c.scale)  
                         ELSE ''  
END Taille 
 FROM syscolumns c INNER JOIN systypes t ON t.usertype=c.usertype 
WHERE c.id=object_id('VotreTable') 
ORDER BY c.colid

1
2
3
4
  
SELECT name  
  FROM sysobjects  
 WHERE type='V'

1
2
3
4
 
SELECT name  
  FROM sysobjects  
 WHERE type='P'

1
2
3
4
5
6
7
8
9
10
11
  
SELECT  
    o.name,  o.type,  c.text,    u.name,   o.crdate  
FROM  
    dbo.sysobjects o  
INNER JOIN dbo.syscomments c 
    ON c.id = o.id  
INNER JOIN dbo.sysusers u 
    ON u.uid = u.uid  
WHERE  
    type = 'TR'

1
2
  
EXEC sp_pkeys @table_name='MaTable'

1
2
  
sp_help MaTable

sp_helpindex {NomTable}

1
2
3
4
select name  
from sysindexes 
where id = object_id("{Nom de la table}") 
and indid between 1 and 254

1
2
3
4
 
select db_name(u.id), d.phyname  
from master..sysusages u, master..sysdevices d 
where u.vstat between d.low and d.high