SQL Server Scripts
open-menu closeme
Home
All SQLServer70 Scripts
Scripts & Commands
Links icon
SQL Server Documentation SQL Server Mgmnt Studio
About
Contact Us
Privacy Statement
rss

  • System-Versioned (Temporal) Tables in SQL Server

    calendar Jun 19, 2026 / Jun 19, 2026 · 6 min read · sql server temporal tables system versioning for system_time history table sys.tables point in time query data audit catalog views database structure metadata scripts  ·
    Share on: twitter facebook linkedin copy

    Every UPDATE and DELETE on a system-versioned table leaves behind a complete, queryable history of the previous row — automatically, with no triggers and no audit-table plumbing. SQL Server records the period each row version was valid and answers point-in-time questions through a single FOR SYSTEM_TIME clause. This is …


    Read More

  • SQL Server Database Schema and Data Dictionary Queries

    calendar Jun 18, 2026 / Jun 19, 2026 · 6 min read · sql server information_schema data dictionary database schema metadata sys.objects sys.columns sys.sql_modules catalog views documentation database structure ansi standard scripts  ·
    Share on: twitter facebook linkedin copy

    Documenting a database starts with a data dictionary: every table, every column, its data type, length, nullability, and default. SQL Server exposes this through the ANSI-standard INFORMATION_SCHEMA views, which produce a portable schema report that reads almost like English and runs unchanged on other ISO-compliant …


    Read More

  • sp_pkeys and Primary Key Metadata in SQL Server

    calendar Jun 16, 2026 / Jun 19, 2026 · 6 min read · sql server sp_pkeys sys.key_constraints sys.index_columns sys.columns sys.types sys.tables sys.objects sys.schemas information_schema primary keys catalog views metadata database structure scripts  ·
    Share on: twitter facebook linkedin copy

    Which columns make up a table's primary key, and in what order are they declared? For a single table, the system stored procedure sp_pkeys answers in one line; for a database-wide inventory, the catalog views behind it give you full control. This post covers both, from the quick lookup to the complete metadata query. …


    Read More

  • sysindexes vs sys.indexes: Legacy and Modern Catalog Views

    calendar Jun 15, 2026 / Jun 19, 2026 · 6 min read · sql server sysindexes sys.indexes sys.partitions sys.allocation_units sys.dm_db_partition_stats sys.index_columns sys.objects sys.schemas catalog views compatibility views metadata database structure scripts  ·
    Share on: twitter facebook linkedin copy

    Plenty of SQL Server scripts still in circulation read rowcnt and dpages straight out of sysindexes — a habit inherited from SQL Server 2000, where that table was the canonical place to find row counts and page totals. The object survives only as the sys.sysindexes compatibility view, is flagged for removal, and …


    Read More

  • SQL Server Catalog Views: sys.tables, sys.indexes, sys.objects

    calendar Jun 14, 2026 / Jun 19, 2026 · 6 min read · sql server catalog views system tables metadata sys.tables sys.indexes sys.objects sys.schemas sys.partitions sys.columns sys.index_columns sys.foreign_keys database structure scripts  ·
    Share on: twitter facebook linkedin copy

    The sys catalog views are the supported, forward-compatible way to read SQL Server metadata, and three of them — sys.objects, sys.tables, and sys.indexes — answer most day-to-day questions about what lives in a database. This script joins them into one inventory of every user table, its schema, its row count, and each …


    Read More

SQLServer70.com

Your Source for SQL Server Scripts
Read More

Recent Posts

  • System-Versioned (Temporal) Tables in SQL Server
  • SQL Server Database Schema and Data Dictionary Queries
  • How to Update Statistics in SQL Server
  • sp_pkeys and Primary Key Metadata in SQL Server
  • sysindexes vs sys.indexes: Legacy and Modern Catalog Views
  • SQL Server Catalog Views: sys.tables, sys.indexes, sys.objects
  • SQL Server DBCC Commands: The Complete DBA Reference Guide
  • SQL Server DBCC CHECKDB: Complete Guide and Repair Options

Categories

SCRIPTS 59 SQL SERVER MAINTENANCE 12 SQL SERVER STRUCTURE 11 SQL SERVER ADMINISTRATION 10 SQL SERVER MONITORING 8 SQL SERVER PERFORMANCE 8 SQL SERVER BACKUP RECOVERY 7 SQL SERVER SECURITY 3

Series

SQL SERVER MAINTENANCE 12 SQL SERVER STRUCTURE 11 SQL SERVER ADMINISTRATION 10 SQL SERVER MONITORING 8 SQL SERVER PERFORMANCE 8 SQL SERVER BACKUP RECOVERY 7 SQL SERVER SECURITY 3

Tags

SQL SERVER 58 DATABASE ADMINISTRATION 39 SQL SCRIPTS 39 MAINTENANCE SCRIPTS 19 PERFORMANCE 16 SYS.TABLES 15 SYS.OBJECTS 14 DATABASE MAINTENANCE 13 DBCC COMMANDS 11 SYS.DATABASES 10 SYSOBJECTS 10 DATABASE STRUCTURE 9 DBA SCRIPTS 9 MONITORING 9
All Tags
ACTIVE SESSIONS2 ADMINISTRATION2 ALTER INDEX1 ANSI STANDARD1 AUTOMATION2 BACKUP1 BACKUP AUDIT1 BACKUP COMPRESSION1 BACKUP MONITORING2 BACKUP RECOVERY6 BACKUP VALIDATION1 BACKUPSET1 BLOCKING2 BOTTLENECK ANALYSIS1 CAPACITY PLANNING2 CARDINALITY ESTIMATION1 CATALOG VIEWS5 CLUSTERED INDEXES1 COLUMNS1 COMPATIBILITY VIEWS1 CONSISTENCY CHECKS2 CONSTRAINT REPORTING1 CONTENTION1 COPY ONLY BACKUP1 CPU CONFIGURATION1 CPU HISTORY1 CPU UTILIZATION1 CURSOR PROGRAMMING1 DATA AUDIT1 DATA DICTIONARY1 DATA TYPES1 DATABASE1 DATABASE ADMINISTRATION39 DATABASE CONNECTIONS1 DATABASE CORRUPTION1 DATABASE FILES1 DATABASE INTEGRITY1 DATABASE MAINTENANCE13 DATABASE MANAGEMENT3 DATABASE MONITORING2 DATABASE OBJECTS1 DATABASE OPTIMIZATION1 DATABASE SCHEMA1 DATABASE SCRIPTS1 DATABASE SECURITY1 DATABASE STRUCTURE9 DBA SCRIPTS9 DBA TOOLS1 DBCC1 DBCC CHECKDB3 DBCC CHECKIDENT2 DBCC COMMANDS11 DBCC DBINFO1 DBCC DBREINDEX2 DBCC FREEPROCCACHE1 DBCC LOGINFO1 DBCC SHRINKFILE2 DEPENDENCIES1 DEV RESTORE1 DIAGNOSTICS1 DIFFERENTIAL BACKUP1 DISK SPACE2 DM DB MISSING INDEX DETAILS1 DM DB MISSING INDEX GROUP STATS1 DM DB SESSION SPACE USAGE1 DM EXEC REQUESTS2 DM EXEC SESSIONS3 DM EXEC SQL TEXT1 DM OS WAIT STATS1 DOCUMENTATION1 DUPLICATE INDEXES1 DYNAMIC SQL2 ERROR LOG1 EXECUTION PLAN1 FILEPROPERTY1 FOR SYSTEM_TIME1 FOREIGN KEYS2 FRAGMENTATION2 FULL BACKUP1 GRANT STATEMENTS1 HEAP TABLES2 HISTORY TABLE1 IDENTITY COLUMNS2 IDENTITY RESEED1 IMPACT ANALYSIS1 INDEX FRAGMENTATION2 INDEX MAINTENANCE4 INDEX OPTIMIZATION1 INDEX REBUILDING1 INDEX SIZE1 INDEX TUNING2 INDEXES4 INDEXING1 INFORMATION_SCHEMA2 INFORMATION_SCHEMA.TABLE_CONSTRAINTS1 INFORMATION_SCHEMA.TABLES1 INTEGRITY CHECK1 JOB MONITORING1 KILL SPID1 LOG MANAGEMENT1 LOGIN MANAGEMENT1 MAINTENANCE SCRIPTS19 MAX SERVER MEMORY1 MAXDOP1 MEMORY CONFIGURATION1 METADATA6 MISSING INDEXES1 MONITORING9 MSDB8 MSDB.DBO.BACKUPMEDIAFAMILY1 MSDB.DBO.BACKUPSET1 NONCLUSTERED INDEXES1 NUMA1 OBJECT DEPENDENCIES1 OBJECT SEARCH1 OPEN TRANSACTIONS1 OPTIMIZATION2 ORPHAN USERS1 PARAMETER SNIFFING1 PERFORMANCE16 PERFORMANCE MONITORING1 PERFORMANCE TUNING7 PERMISSIONS2 PLAN CACHE2 POINT IN TIME QUERY1 POINT IN TIME RESTORE1 PRIMARY KEYS3 QUERY OPTIMIZATION2 QUERY OPTIMIZER1 QUERY PERFORMANCE1 QUERY TUNING3 REBUILD REORGANIZE1 RECOVERY1 REFACTORING1 REFERENTIAL INTEGRITY1 REPORTING3 RESTORE1 RESTORE VERIFYONLY1 RING BUFFER1 ROLE MEMBERSHIPS1 SCHEMA ANALYSIS2 SCHEMA AUDIT1 SCHEMA DOCUMENTATION1 SCHEMA MANAGEMENT1 SCRIPTS9 SECURITY3 SECURITY AUDIT2 SERVER MONITORING1 SESSION MANAGEMENT1 SP CONFIGURE1 SP_CHANGE_USERS_LOGIN1 SP_CONFIGURE2 SP_PKEYS2 SP_READERRORLOG1 SP_SPACEUSED1 SP_UPDATESTATS1 SPACE MANAGEMENT1 SPACE USAGE1 SQL1 SQL SCRIPTS39 SQL SERVER58 SQL SERVER AGENT1 SQL SERVER MONITORING1 SQLSERVER PROCESS UTILIZATION1 STATISTICS2 STORAGE2 STORED PROCEDURES1 SYS.ALL_COLUMNS1 SYS.ALL_OBJECTS1 SYS.ALLOCATION_UNITS3 SYS.COLUMNS7 SYS.COMPUTED_COLUMNS1 SYS.CONFIGURATIONS1 SYS.DATABASE_FILES2 SYS.DATABASE_PERMISSIONS1 SYS.DATABASE_PRINCIPALS2 SYS.DATABASE_ROLE_MEMBERS1 SYS.DATABASES10 SYS.DM_DB_INDEX_PHYSICAL_STATS7 SYS.DM_DB_INDEX_USAGE_STATS5 SYS.DM_DB_MISSING_INDEX_DETAILS1 SYS.DM_DB_MISSING_INDEX_GROUP_STATS1 SYS.DM_DB_MISSING_INDEX_GROUPS1 SYS.DM_DB_PARTITION_STATS2 SYS.DM_DB_STATS_PROPERTIES1 SYS.DM_EXEC_CACHED_PLANS1 SYS.DM_EXEC_QUERY_PLAN1 SYS.DM_EXEC_QUERY_STATS1 SYS.DM_EXEC_REQUESTS2 SYS.DM_EXEC_SESSIONS2 SYS.DM_EXEC_SQL_TEXT4 SYS.DM_OS_PERFORMANCE_COUNTERS1 SYS.DM_OS_RING_BUFFERS1 SYS.DM_OS_SYS_INFO1 SYS.DM_OS_VOLUME_STATS1 SYS.DM_OS_WAIT_STATS1 SYS.DM_OS_WAITING_TASKS1 SYS.DM_SQL_REFERENCED_ENTITIES1 SYS.DM_SQL_REFERENCING_ENTITIES1 SYS.DM_TRAN_ACTIVE_TRANSACTIONS1 SYS.DM_TRAN_LOCKS1 SYS.FOREIGN_KEY_COLUMNS1 SYS.FOREIGN_KEYS4 SYS.IDENTITY_COLUMNS1 SYS.INDEX_COLUMNS5 SYS.INDEXES9 SYS.KEY_CONSTRAINTS2 SYS.MASTER_FILES2 SYS.OBJECTS14 SYS.PARTITIONS5 SYS.SCHEMAS5 SYS.SERVER_PRINCIPALS1 SYS.SP_ENUMERRORLOGS1 SYS.SQL_EXPRESSION_DEPENDENCIES1 SYS.SQL_MODULES2 SYS.STATS1 SYS.TABLES15 SYS.TYPES2 SYS.VIEWS1 SYSCOLUMNS1 SYSDATABASES1 SYSINDEXES3 SYSJOBHISTORY1 SYSJOBS1 SYSOBJECTS10 SYSTEM IDLE PROCESS1 SYSTEM TABLES4 SYSTEM VERSIONING1 T-SQL3 TABLE ANALYSIS1 TABLE MAINTENANCE1 TABLE SIZE1 TABLE STATISTICS1 TEMPDB1 TEMPORAL TABLES1 TRANSACTION LOG2 TRANSACTION LOG BACKUP1 UPDATE STATISTICS2 VIEWS1 VIRTUAL LOG FILES1 WAIT STATISTICS1 WAIT TYPES3 XP_READERRORLOG1
[A~Z][0~9]
SQLServer70.com

Copyright  SQLSERVER70.COM. All Rights Reserved

to-top