1:Select * from master.dbo.sysdatabases 2:Select * from sysobjects where xtype = 'U' 3:Select * from sysobjects where xtype = 'U'
select name from master..sysdatabases select name from yourdatabse..sysobjects where xtype='u' and name<>'dtproperties' select name from yourdatabase..sysobjects where xtype='u' and name='user'
Select name from sysobjects where xtype = 'U'
select name from sysdatabasesselect * from sysobjects where xtype in ('U','S')select * from sysobjects where xtype='U' and status>0
2:Select * from sysobjects where xtype = 'U'
3:Select * from sysobjects where xtype = 'U'
select name from yourdatabse..sysobjects where xtype='u' and name<>'dtproperties'
select name from yourdatabase..sysobjects where xtype='u' and name='user'