SQLServerCentral.com Scripts tagged Metadata

List all Columns in Server Part 2

Tue, 08 Feb 2011 07:00:00 UT

Generates a list of Server, Database, Table , Column Names and properties

Object Explore

Tue, 24 Aug 2010 06:00:00 UT

summary information and metrics for any column in a given Table/View. Metrics include: number of records, distinct records, nulls, min, max, std, quartiles, kurtosis, skew, etc.

Table Index Store and Create

Fri, 17 Jul 2009 06:00:00 UT

Query to save all index metadata

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.

Truncate Referenced Table

Mon, 19 Jan 2009 07:00:00 UT

Often during the development phase one is required to truncate a table. often the task of removing foreign key references is necessary to truncate. this sp takes the pain out of it.

Encrypt All Stored procedures at once

Thu, 10 Sep 2009 06:00:00 UT

this code encrypts all stored procedures that meet a certain format. this code is easy to change to suit your particular needs, but be sure to back up your stored procs first.

search every database on server from a single sp

Fri, 19 Dec 2008 07:00:00 UT

i have recently had the need to search the every database on the server for a particular string. i came up with this... it has lots of room for improvement but it works

AUTOGENERATE INSERT UPDATE SELECT STATEMENTS UPDATED

Tue, 08 Jan 2013 07:00:00 UT

I have made an update of this script http://www.sqlservercentral.com/scripts/Metadata/64603/. the new version includes can generate 4 stored procedures for every table in a database

Check SQL Server performance at a glance
We consulted 1000 SQL Server professionals to make SQL Monitor’s UI as clear as possible. Start monitoring with a free trial.

How to Drop Unused Empty Redundant columns

Thu, 27 Nov 2008 07:00:00 UT

Often during the development lifecycle columns are added to tables that become redundant or remain unused. this script removes unused (empty) columns

AUTOGENERATE INSERT UPDATE SELECT STATEMENTS

Fri, 21 Nov 2008 07:00:00 UT

use metadata to generate basic create procedure statements for insert update and select

Compare and sync databases with SQL Compare
“SQL Compare is fast, extremely easy to use, full-featured and affordable. I wouldn't bother messing around with anything else.” Adam Machanic, SQL Server MVP. Download a 14-day free trial.

Find Foreign Keys

Fri, 12 Sep 2008 01:51:32 UT

This script lists all foreign keys with parent and child table information

Get your SQL Server database under version control now!
Version control is standard for applications, but databases haven’t caught up. So how can you bring database development up to speed? Why should you start? Find out…

get users across all databases on the SQL Server instance

Thu, 24 Jul 2008 06:00:00 UT

Quick way to get all users on all Databases