home *** CD-ROM | disk | FTP | other *** search
/ PC Pro 1995 September / PCPRO2_995.ISO / superoff / sql / sorcview.sql < prev    next >
Encoding:
Text File  |  1995-03-05  |  173 b   |  4 lines
  1. CREATE VIEW rowcount (num_rows, table_name) AS
  2.     SELECT t.count, t.table_name FROM systable t, sysuserperm p
  3.         WHERE t.creator = p.user_id AND p.user_name = 'so'
  4.