Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag Metadata Rss

Search for any content tagged metadata

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 12 of 12   
 

List all Columns in Server Part 2

Generates a list of Server, Database, Table , Column Names and properties  Read more...
By shanu hoosen 2011/02/08 | Source: SQLServerCentral.com | Category: metadata
Rating: |  Discuss |   Briefcase | 1,310 reads

Object Explore

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.  Read more...
By Robin van Schaik 2010/08/24 | Source: SQLServerCentral.com | Category: data exploration
Rating: |  Discuss |   Briefcase | 1,026 reads

Table Index Store and Create

Query to save all index metadata  Read more...
By Jorge Novo-@ETLDEVDBA 2009/07/17 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 857 reads

Loop Through every table in a DB

This Script has been build to list all the tables in a database without using a cursor.   Read more...
By Chris Morton 2009/01/20 | Source: SQLServerCentral.com | Category: metadata
Rating: |  Discuss |   Briefcase | 2,007 reads

Truncate Referenced Table

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.  Read more...
By Chris Morton 2009/01/19 | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 1,251 reads

Encrypt All Stored procedures at once

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.   Read more...
By Chris Morton 2009/09/10 | Source: SQLServerCentral.com | Category: with encryption
Rating: |  Discuss |   Briefcase | 3,206 reads

search every database on server from a single sp

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  Read more...
By Chris Morton 2008/12/19 | Source: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 951 reads

AUTOGENERATE INSERT UPDATE SELECT STATEMENTS UPDATED

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  Read more...
By Chris Morton 2013/01/08 | Source: SQLServerCentral.com | Category: autogenerate parameters
Rating: |  Discuss |   Briefcase | 3,047 reads

How to Drop Unused Empty Redundant columns

Often during the development lifecycle columns are added to tables that become redundant or remain unused. this script removes unused (empty) columns  Read more...
By Chris Morton 2008/11/27 | Source: SQLServerCentral.com | Category: alter table
Rating: |  Discuss |   Briefcase | 1,140 reads

AUTOGENERATE INSERT UPDATE SELECT STATEMENTS

use metadata to generate basic create procedure statements for insert update and select  Read more...
By Chris Morton 2008/11/21 | Source: SQLServerCentral.com | Category: metadata
Rating: |  Discuss |   Briefcase | 3,588 reads

Find Foreign Keys

This script lists all foreign keys with parent and child table information  Read more...
By Jack Corbett 2008/09/11 | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 1,324 reads

get users across all databases on the SQL Server instance

Quick way to get all users on all Databases  Read more...
By Mani Singh 2008/07/24 | Source: SQLServerCentral.com | Category: metadata
Rating: |  Discuss |   Briefcase | 1,576 reads
   Items 1 to 12 of 12