June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – 2005 – List Tables in Database Without Primary Key

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Database, SQL Constraint and Keys, SQL Scripts, SQL System Table
This is very simple but effective script. It list all the table without primary keys. USE DatabaseName; GO SELECT SCHEMA_NAME(schema_id) AS SchemaName,name AS TableName FROM sys.tables WHERE OBJECTPROPERTY(OBJECT_ID,'TableHasPrimaryKey') = 0 ORDER BY SchemaName, TableName; GO Reference : Pinal Dave (https://blog.sqlauthority.com), BOL
Read More

SQL SERVER – Good, Better and Best Programming Techniques

Pinal Dave
SQL, SQL Interview Questions and Answers, SQL Performance, SQL Server, SQL Tips and Tricks
SQL Backup and Restore, SQL Constraint and Keys, SQL Cursor, SQL Download, SQL Function, SQL Index, SQL Joins, SQL Scripts, SQL Server DBCC, SQL Server Security, SQL Stored Procedure, SQL Trigger
A week ago, I was invited to meeting of programmers. Subject of meeting was “Good, Better and Best Programming Techniques”. I had made small note before I went to meeting, so if I have to talk about or discuss SQL Server it can come handy. Well, I did not get…
Read More

SQL SERVER – Difference Between Unique Index vs Unique Constraint

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Constraint and Keys, SQL Index, SQL Scripts
Unique Index and Unique Constraint are the same. They achieve same goal. SQL Performance is same for both. Add Unique Constraint ALTER TABLE dbo.<tablename> ADD CONSTRAINT <namingconventionconstraint> UNIQUE NONCLUSTERED ( <columnname> ) ON [PRIMARY] Add Unique Index CREATE UNIQUE NONCLUSTERED INDEX <namingconventionconstraint> ON dbo.<tablename> ( <columnname> ) ON [PRIMARY] There…
Read More