SYSTEMSYNONS :
synonym
synowner , ( PUBLIC ())
tname
tabowner
, Adrian Clients , Diane, Customers . ( 24.8):
SELECT *
FROM SYSTEMSYNONS
WHERE tname = 'Customers'
=============== SQL Execution Log ================
| SELECT * |
| FROM SYSTEMSYNONS |
| WHERE tname = 'Customers' |
|; |
| ================================================= |
| synonym synowner tname tabowner |
| ----------- ----------- ---------- ---------- |
| Clients Adrian Customers Diane |
| Customers PUBLIC Customers Diane |
===================================================
24.8:
, . , , . , ( 24.9):
SELECT a.tname, a.cname, iname, cposition
FROM SYSTEMCOLUMNS a, SYSTEMINDEXES b
WHERE a.tabowner = b.tabowner AND a.tname = b.tname AND
a.cnumber = b.cnumber
ORDER BY 3 DESC, 2;
, . salesno snum; - ( ) iname. , custsale, , . snum cnum , snum , cposition.
=============== SQL Execution Log ================
| SELECT a.tname, a.cname, iname, cposition |
| FROM SYSTEMCOLUMNS a, SYSTEMINDEXES b |
| WHERE a.tabowner = b.tabowner |
| AND a.tname = b.tname |
| AND a.cnumber = b.cnumber |
| ORDER BY 3 DESC, 2; |
| ================================================= |
| tname cname iname cposition |
| ----------- ------- -------- ------------ |
| Salespeople sname salesno 1 |
| Customers cnum custsale 2 |
| Customers snum custsale 1 |
===================================================
24.9.
. :
SELECT *
FROM SYSTEMCOLUMNS
WHERE tname IN (SELECT tname
FROM SYSTEMCATALOG);
, , . , , , SYSTEMTABCOLS, SYSTEMTABLES.
|
|
, SQL , . . , ( ) SYSTEMCATALOG SYSTEMCOLUMNS. , .
, , SQL . , SQL , , , , SQL, .
SQL
, , , , , .
, , . , , .
, .
(. A .)