Technical Article

The SQL 7.0 Query for listing of all users tables

,

The SQL 7.0 Query for listing of all users tables with owner, no of rows and Date/Time created is as follows

--The SQL 7.0 Query for listing of all users tables with owner, no of rows and Date/Time created is as follows.
/*SQL 7.0*/SELECT u.name as 'Owner', o.name as 'Table',
(SELECT rows FROM sysindexes WHERE id = OBJECT_ID(u.name + '.' + o.name) AND indid < 2 ) as 'No of Rows', 
o.crdate as 'Date Time Created'
FROM sysobjects o, sysusers u 
WHERE xtype = 'U' and o.status >= 0 and o.uid = u.uid 
ORDER by u.name, o.name
/*END*/

Rate

Share

Share

Rate