22,207
社区成员
发帖
与我相关
我的任务
分享
select * from sys.objects o
inner join sys.schemas s
on o.schema_id=s.schema_id
where s.name='zhbaobaocom'
USE [db_name];-
GO
SELECT name, object_id, type_desc
FROM sys.objects
WHERE OBJECTPROPERTY(object_id, N'SchemaId') = SCHEMA_ID(N'zhbaobaocom')
ORDER BY type_desc, name;
GO