sql server 2000
------------------
USE Master
GO
SELECT * FROM sysdatabasesuse Northwind
go
select * from sysobjects where type = 'u'
------------------
USE Master
GO
SELECT * FROM sysdatabasesuse Northwind
go
select * from sysobjects where type = 'u'
go
select name from sysobjects where xtype='u' and name!='dtproperties'go
use master
SELECT name FROM sysdatabases