SQL Server Education (by the geeks, for the geeks)
One of the most common questions on forums is how to disable enable indexes SQL Server. Index can be disabled or enabled as shown below USE AdventureWorks2014 GO — Query1: disable …
Disable Enable Indexes SQL Server Read MoreA Jr. Developer asked me why a primary key not null in SQL Server. A primary key uniquely identifies a row in a table and a NULL can’t identify any row. …
Primary key not null in SQL Server Read MoreHere’s a T-SQL find tables without primary key. SELECT OBJECT_SCHEMA_NAME(tables.object_id,db_id()) AS SchemaName, tables.name As TableName FROM sys.tables tables join sys.indexes indexes ON tables.object_id=indexes.object_id WHERE indexes.is_primary_key=0 GO The sys.indexes.is_primary_key column indicates whether …
T-SQL find tables without primary key Read More