Tag Archives: Schema

Add trigger to all tables in schema

The code below will add a trigger to all the tables in a specific schema on the Microsoft


Getting accessible schemas for a user

The code below gets the schemas from a Microsoft SQL-server that is accessible for a given user. It is made with SAS-code but the SQL-statement can be used regardless of using SAS.