TransWikia.com

Deleting attribute fields through SQL Server Management Studio

Geographic Information Systems Asked by Janis on August 31, 2021

I have a problem. After appending annotations into the feature class on the SQL Server database I need to delete extra attribute fields that where made in the process. Usually I would just simply use Delete Field tool. However because people are working on this database I can’t do this because of unique lock. I also have Python script that disconnects everyone and delete these fields during the night, but I want to find the way to do this when people are connected. So I had an idea that I could delete these fields through SQL Server Management Studio but I’m afraid that this may cause problems to database or text feature class.

Is it safe to delete attribute fields through SQL Server Management Studio?

I’m using ArcGIS Desktop 10.6.1 and SQL Server Management Studio 18.

One Answer

NO!

Definitely not safe to do this. Either announce a maintenance outage during the day where you can safely do this without users connected, or run your existing process overnight.

The Enterprise geodatabase has a lot more links behind the scenes than you may be aware of, deleting through SQL Server Management Studio won't be the correct process and has the potential (probably quite high) to corrupt your geodatabase. Don't do it. You need to use the tools provided.

So again, no, it is not safe, use the tools provided in the way they are intended.

Correct answer by Midavalo on August 31, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP