system-tables

Oracle db view/system table to check if given part of a package is a Procedure or a Function

I am using the Oracle system tables to get some metadata about the Packages in our database. Here is one of my queries: select AP.PROCEDURE_NAME from ALL_PROCEDURES ap where ap.object_name = :object_name and ap.owner=:owner and ap.procedure_name is not NULL and ap.procedure_name like :procedure_name I also want to find o...

MS Sql Server Object Creation / Alter Script

Hi, In Sql Server when you select to modify a SP or UDF it loads the objects alter query in a query window. Are these queries accessible in a system table so I can store the alter statements somewhere? It looks like syscomments has some objects but not all of them. Thanks ...

What privileges do you need to access sys.$ tables?

What privileges do you need to be able to query the sys.obj$, sys.col$ etc system tables directly? ...

How to check if a Constraint exists in Sql server?

I have this sql: ALTER TABLE dbo.ChannelPlayerSkins DROP CONSTRAINT FK_ChannelPlayerSkins_Channels but apparently, on some other databases we use, the constraint has a different name. How do I check if there's a constraint with the name FK_ChannelPlayerSkins_Channels. ...

Unable to update sys.columns - any other approach?

Hello! I just found out, that since I created my DB on a different server that had a different collation, then immigrated to a new server with new collation, now I keep on having trouble, and I decided to change all the values of the old collation. So I tried to execute this query: sp_configure "Allow Updates", 1 GO RECONFIGURE WITH O...