Apr 15, 2013 · When using PostgreSQL v9.1, how do I list all of the schemas using SQL? I was expecting something along the lines of: SELECT something FROM pg_blah;

Oct 13, 2021 · How would be better to design the database schema having many transaction types? It also should be easy to get a list of all transactions of an account. The simplest way to …

I am trying to delete a principal from the database but can't because it owns a schema. When I go to edit the user, however, the box to uncheck schema is blue and unremovable. How can I …

SELECT * FROM fn_my_permissions('Database.Schema.Table', 'OBJECT'); REVERT; If the user is tied to an AD user or group, consider running repadmin /syncall to force any changes made …

Nov 1, 2016 · I'm designing a schema to support logging of user activity, where users must be able to search: Across all events (events of any type), with datetime range, by username; …

(SQL-Server) What tool do you use? Documentation Storage Format for database schema/meta-data? Word documents Excel spreadsheet Plain Text Documentation process or policies? I …

Nov 13, 2016 · 49 I have a database named "A" which has two schemas "B" and "C". I want to backup and restore Schema "B" (including data) on a different server. Not sure how to do this …

5 While going through Database architecture I came across Schema's . I am very much confused with: Logical schema Physical schema How these two schema exist in the Database? How …

May 8, 2023 · What is the difference (if any) between a database, a user, and a schema?

Apr 23, 2019 · I would like all user logins to have the ability to create, drop, select etc. freely for all objects where the schema is unspecified or specified as "dbo" but to only have read-only …