Columns that are primary keys in a database
Below is a SQL Server 2000 query to return all columns that are primary keys to tables in a database
2002-11-01
216 reads
Blogs
T-SQL Tuesday #137–Notebook Uses
By Steve Jones
It’s actually my month to host T-SQL Tuesday, and I came up with the...
Daily Coping 13 Apr 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Converting a SQL Server Docker image to a WSL2 Distribution
Windows Subsystem for Linux is probably my favourite feature of Windows 10. It gives...
Forums
connect to mdf file of localDB
Potentially dumb question. There is 1 x ldf & 1 x mdf for DB1. ...
Incorrect update
Hello, I made mistake during updating cells in table.In column that contains int type,...
Log Shipping version upgrade oddity
Hi, I've come across an odd situation, and was wondering if anyone can explain...
Ask SSC