SELECT TOP (100) PERCENT s.name + '.' + o.name AS name FROM sys.sysobjects AS o
LEFT OUTER JOIN sys.schemas AS s ON s.schema_id = o.uid WHERE o.xtype = 'U' AND
(o.name <> 'dtproperties') AND (o.name <> 'sysdiagrams') AND (o.name LIKE N'%%') ORDER BY name
这条SQL语句是用来取出数据库中所有的表名 但是取出来的每个表名都有个前缀-》dbo.
怎样修改这条SQL语句才可以取出不带dbo.前缀的所有表名
SELECT TOP (100) PERCENT o.name AS name FROM sys.sysobjects AS o
LEFT OUTER JOIN sys.schemas AS s ON s.schema_id = o.uid WHERE o.xtype = 'U' AND
(o.name <> 'dtproperties') AND (o.name <> 'sysdiagrams') AND (o.name LIKE N'%%') ORDER BY name
LEFT OUTER JOIN sys.schemas AS s ON s.schema_id = o.uid WHERE o.xtype = 'U' AND
(o.name <> 'dtproperties') AND (o.name <> 'sysdiagrams') AND (o.name LIKE N'%%') ORDER BY name
FROM sys.sysobjects AS o
LEFT OUTER JOIN sys.schemas AS s ON s.schema_id = o.uid WHERE o.xtype = 'U' AND
(o.name <> 'dtproperties') AND (o.name <> 'sysdiagrams') AND (o.name LIKE N'%%') ORDER BY name
select name from sysobjects where type='U'
FROM sys.sysobjects AS o
WHERE o.xtype = 'U' AND
(o.name <> 'dtproperties') AND (o.name <> 'sysdiagrams')
ORDER BY o.name
LEFT OUTER JOIN sys.schemas AS s ON s.schema_id = o.uid WHERE o.xtype = 'U' AND
(o.name <> 'dtproperties') AND (o.name <> 'sysdiagrams') AND (o.name LIKE N'%%') ORDER BY name