Newest 'inheritance+schema' Questions

8 votes

1 answer

10k views

What is the purpose of "Schema Owner"?

If I create a new schema and set the schema owner to another schema, for example dbo, what is the meaning of that in regards to my new schema? Does my new schema inherit the same permissions from it'...

J.D.

39.5k

asked Sep 10, 2019 at 21:18

5 votes

1 answer

3k views

Transfer row from 'parent' to 'child' without creating duplicate and without knowing all 'parent' columns

I want to set up a database with different schemas that correspond to different data-entry systems. There needs to be a “master” (administration) schema with a “parties” table, and multiple other ...

user2437443

143

asked Jun 20, 2018 at 23:01

1 vote

0 answers

284 views

Alter schema of Access 2013 database with linked table

I'm trying to change the schema of an Access 2013 table. I want to lengthen some of the text fields. When I change the schema and try to save I get dialog with Operation is not supported for this type ...

abalter

127

asked Jun 18, 2015 at 14:20

7 votes

2 answers

5k views

Polymorphic Association - is it bad?

In the following schema: Collections Upvotes Reports Upvotes Reviews Upvotes I'm tempted to have a single Upvotes table with a single "entityId" column that stores either the CollectionId, ...

RobVious

171

asked Dec 8, 2013 at 17:01

Stack Exchange Network

All Questions