home *** CD-ROM | disk | FTP | other *** search
/ Computer Shopper 132 / dpcs0299.iso / Business / Superoff / super / Sql / SORCVIEW.WQL < prev    next >
Encoding:
Text File  |  1996-02-29  |  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.