|
unfortunately not. I suspect whatever is used to fill the result dialog does have what I'm looking for; but as is all it tells me is that most tables in the system have a dependency on the users table (created/updated by fields so they have userId FKs); but not what column the dependency is on so I could filter it by the one I want to get rid of.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
|
|
|
|
|
You need to add a few joins to make it useful.
Here's something I found on SO and modified for my own use:
USE MyDatabase
DECLARE @SchemaName nvarchar(128) = 'dbo'
DECLARE @TableName nvarchar(128) = 'TableWithColumnToRemove'
DECLARE @ColumnName nvarchar(128) = 'ColumnToRemove'
;
SELECT SCHEMA_NAME(o1.schema_id) + '.' + o1.name ReferencingObject
,SCHEMA_NAME(o2.schema_id) + '.' + ed.referenced_entity_name ReferencedObject
,c.name ColumnName
,o2.type ReferencedObjectType
,o1.type ReferencingObjectType
FROM sys.sql_expression_dependencies ed
JOIN sys.objects o1 ON ed.referencing_id = o1.object_id
JOIN sys.objects o2 ON ed.referenced_id = o2.object_id
JOIN sys.sql_dependencies d ON ed.referencing_id = d.object_id
AND d.referenced_major_id = ed.referenced_id
JOIN sys.columns c ON c.object_id = ed.referenced_id
AND d.referenced_minor_id = c.column_id
WHERE 1=1
AND SCHEMA_NAME(o2.schema_id) = @SchemaName
AND o2.name = @TableName
AND c.name = @ColumnName
ORDER BY ReferencedObject
,c.column_id;
modified 14-Oct-21 10:33am.
|
|
|
|
|
Thank you, that looks like it does exactly what I was looking for.
Did you ever see history portrayed as an old man with a wise brow and pulseless heart, weighing all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius
|
|
|
|
|
If this isn't a programming qvestion, I don't know what programming is ...
|
|
|
|
|
I'm on the fence about it.
There are two things I'd like to know.
Who among you has installed it, and what do you think?
Also, is the free upgrade to Windows 11 time limited? Do I have to get it while the getting is good, or can i sit on it for 3-6 months?
Real programmers use butterflies
|
|
|
|
|
Installed, not overly impressed. I like the new setup (as in Control Panel) format, but that and rounded corners is about all I've noticed so far. I'd stick with 10 for now, especially if you have an AMD CPU.
As far as I've heard, there isn't a time limit on the upgrade. I'm sure it will get louder and louder, but not switch to pay. I could have missed it though. I'm pretty much out of the loop these days.
TTFN - Kent
|
|
|
|
|
Thanks!
Real programmers use butterflies
|
|
|
|
|
I saw yesterday that my Win10 (in AMD) told me, my PC is not suitable for Updating to 11.
I drunk a glass of Champagne
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
I did a clean install as mentioned a few threads down. The only negative comment I have is that Edge gets unstable unexpectedly. While annoying, it is not so bad that I want to revert to Windows 10 (for the moment)
I hope that it is just a video driver or something else that will be fixed soon.
If you do go for it: Why not make an image (like the Macrium variety) of your current system, so you can go back to 10 in a few minutes? You should have a recent image in any case to cover eventualities like Ransom attacks.
Get me coffee and no one gets hurt!
|
|
|
|
|
That's true. I have 7TB online though, and a 2TB system drive, so it could take awhile.
Real programmers use butterflies
|
|
|
|
|
You only need to backup the OS partition.
Data is not needed for that and should be in a different backup process (at least IMHO).
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
I'm going to wait for all the dust to settle, right now it seems just too unstable to be practical for a dev machine.
The less you need, the more you have.
Even a blind squirrel gets a nut...occasionally.
JaxCoder.com
|
|
|
|
|
That's what my better nature is telling me. But I don't want to miss an opportunity if there's one to be missed.
Real programmers use butterflies
|
|
|
|
|
Yeah I did that with 10 and ended up paying for it...and it wasn't cheap.
But I don't want to be doing their QA for them either!
The less you need, the more you have.
Even a blind squirrel gets a nut...occasionally.
JaxCoder.com
|
|
|
|
|
also that.
this is why i am handwringing over the decision.
Real programmers use butterflies
|
|
|
|
|
It's a gamble; if you can't afford to lose don't play.
The less you need, the more you have.
Even a blind squirrel gets a nut...occasionally.
JaxCoder.com
|
|
|
|
|
Right now I can afford it, just not sure I want to.
Real programmers use butterflies
|
|
|
|
|
Didn't you used to work there?
You should know better than most about their QA process.
I’ve given up trying to be calm. However, I am open to feeling slightly less agitated.
|
|
|
|
|
It has been over a decade since I worked there. I'm not sure how long they're dogfooding for these days.
Real programmers use butterflies
|
|
|
|
|
Don't be fooled as we were with Windows Vista. Back then, XP was good enough for me, until after Win 7 came along.
|
|
|
|
|
Quote: right now it seems just too unstable to be practical for a dev machine
In my experience it is very stable running the Android Studio IDE. Haven't tried Visual Studio yet. I want to stick out my neck and say it's OK for development work.
Surfing the web can get a little annoying.
Get me coffee and no one gets hurt!
|
|
|
|
|
I barely use Visual Studio these days, but I use VS Code a lot. That would be my litmus test, if anything.
Real programmers use butterflies
|
|
|
|
|
I'm doing embedded development as well as desktop stuff so not sure how the other IDE's, drivers etc. will play with 11? And right now I don't have the time or the inclination to find out.
The less you need, the more you have.
Even a blind squirrel gets a nut...occasionally.
JaxCoder.com
|
|
|
|
|
Me too, and that's my biggest concern, is whether or not MiniGW, platformIO, etc are all going to play nicely with the new OS.
Real programmers use butterflies
|
|
|
|
|
It is ok for development work apart from the reduced organisational flexibility of the start screen (ok on a laptop or pad in order to pretend to be an ipad, but useless for a development desktop).
|
|
|
|