home *** CD-ROM | disk | FTP | other *** search
/ PC Plus SuperCD (UK) 1998 August / PC Plus SuperCD 50b Issue 142 (CD142b) (August 1998).iso / full / super / disk1 / SQL / SORCVIEW.SQL < prev    next >
Encoding:
Text File  |  1996-02-27  |  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.