SQL 2005 - List Primary Key Columns
Will list Table Name, Constraint name and Primary Key Column Name.
2012-06-29 (first published: 2008-03-20)
2,471 reads
Sandeep Saretha
SQL 2005 - List value of 'Not For Replication'
Script will list all identity columns with valus of 'Not for Replication'
2008-05-13 (first published: 2008-03-20)
732 reads
2008-03-19 (first published: 2008-01-24)
3,549 reads
Blogs
Setting Up Always Encrypted
In this post we're going to go through the steps to set up Always...
Using Azure Automation and Runbooks to Run Azure SQL Database Maintenance Tasks
I’ve been using Azure SQL Database for quite some while and have set up...
Create and Verify Microsoft Fabric Capacity
From June 1, 2023, Microsoft Fabric (preview) capacities are available via the Azure portal....
Forums
how to determine if we can delete the index can be removed
In SQL Server database, there is a table InventDim with two indexes: Idx1 with...
how to determine if we can delete the index can be removed
In SQL Server database, there is a table InventDim with two indexes: Idx1 with...
how to determine if we can delete the index can be removed
The table InventDim has some indexes, we create one index idx1 which has index...
Ask SSC