ArcGIS Pro Error drop schema #186

Error drop shema

Drop schema https://stackoverflow.com/questions/1929455/error-trying-to-delete-database-user-account-schema

try :

drop from ssms

error message output :

TITLE: Microsoft SQL Server Management Studio
------------------------------

Drop failed for Schema 'tesvidya_user3'.  (Microsoft.SqlServer.Smo)

For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=16.100.37971.0&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+Schema&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Cannot drop schema 'tesvidya_user3' because it is being referenced by object 'i28_get_ids'. (Microsoft SQL Server, Error: 3729)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=14.00.3456&EvtSrc=MSSQLServer&EvtID=3729&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

drop shema name from command:

select shema where shema_id tesvidya_user3

SELECT * FROM sys.objects 
where schema_id = SCHEMA_ID('tesvidya_user3')
--AND name = 'i28_get_ids'

delete shema name i28_get_ids

DROP <object type> ext_owner.getroles;

OR delete objects from store procedure i28_get_ids

or move owner chema

ALTER SCHEMA <some other schema> TRANSFER ext_owner.getroles;

delete shema name tesvidya_user3

DROP SHEMA tesvidya_user3

image.png

24 KiB

image.png

2.7 MiB

image.png

2.4 MiB

image.png

2.3 MiB

image.png

46 KiB