SQLServerCentral.com Scripts tagged Table

Find Primary Column of all tables in database

Tue, 02 Oct 2012 06:00:00 UT

This code helps in finding Primary Keys for all tables in a database.

Get information from tables

Fri, 08 Jul 2011 06:00:00 UT

Give information in tables such as type size and description of each of the columns

Stored procedure to script tables, has many options

Tue, 01 Feb 2011 07:00:00 UT

I needed a fast way of creating identical copies of multiple tables. The criteria was to make identical copies of tables for a specific schema. Well there it started.

Find botched constraints, idxs, fks

Wed, 04 Aug 2010 06:00:00 UT

Shows awesome view of columns with constraints and indexes and foreign keys to spot errors fast.

Estimating the table size...

Thu, 02 Jul 2009 06:00:00 UT

This is an effort to program the "Estimating the Table size" section given in BOL.

Get alerts within 15 seconds of SQL Server issues
SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

Loop Through every table in a DB

Tue, 20 Jan 2009 07:00:00 UT

This Script has been build to list all the tables in a database without using a cursor.

Counter Table (table of numbers) Setter-Upper for SQL Server 2005

Wed, 06 Aug 2008 02:57:05 UT

Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 622, 386884, and 240641848 numbers.

Counter Table (table of numbers) Setter-Upper for SQL Server 2000

Wed, 06 Aug 2008 02:50:45 UT

Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 620, 384400, and 238328000 numbers.

Insertion Query Creation of a Table in Milliseconds

Thu, 30 Aug 2012 06:00:00 UT

This script helps you to constitute insertion procedures for tables in a millisecond.