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

Scripts with tag columns Rss

Search for any content tagged columns

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 14 of 14   

Advanced Display Table and Column Info

A view that presents Schema, Table, Fields and Data Types, Defaults and First 10 triggers for the table.  Read more...
By Luis Chiriff 2014/01/03 | Source: | Category: columns
Rating: |  Discuss |   Briefcase | 1,621 reads

Tables and rows listing

Simple script which create a list of all the tables and rows of the selected DB.  Read more...
By Claudio Tregambe 2013/02/11 | Source: | Category: tables
Rating: |  Discuss |   Briefcase | 1,003 reads

Search for String in all columns

Find all columns containing a string value across all tables and schemas.  Read more...
By Wes Henriksen 2012/11/07 | Source: | Category: search
Rating: |  Discuss |   Briefcase | 1,646 reads

Table Search Based on the Column

To Find all the tables based on a particular column  Read more...
By Bhargav Sesham 2012/11/06 | Source: | Category: table search
Rating: |  Discuss |   Briefcase | 1,201 reads

Generate alter datatype script for entire database

ntext, text, and image (Transact-SQL). This script will alter the data type from image to varbinary(max) which is very much required as the data type is out of support.  Read more...
By Venugopal Saride 2011/11/28 | Source: | Category: ntext
Rating: |  Discuss |   Briefcase | 831 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: | Category: data exploration
Rating: |  Discuss |   Briefcase | 1,030 reads

Display rows vertically

A script to view selects of fat rows vertically with columns in alpha order  Read more...
By Steve McRoberts 2009/10/05 | Source: | Category: select
Rating: |  Discuss |   Briefcase | 1,833 reads

Search for a Column in all databases

This Script can be used for searching a column in SQL server 2005  Read more...
By Sandesh Segu 2009/08/05 | Source: | Category: columns
Rating: |  Discuss |   Briefcase | 958 reads

Object Search

Procedure to search any database (or a combination of databases, including all) for a specific string found in column names, object names, and / or object definitions.  Read more...
By Sean Smith 2014/06/20 | Source: | Category: object
Rating: |  Discuss |   Briefcase | 4,007 reads

Find Text in all columns of all tables in a Database

Will find the Table Name, Column Name and the number of occurances some text appears in a database.  Read more...
By Joshua A. Walker 2013/12/20 | Source: | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,468 reads

Find a Table's Metadata

Stored Procedure that returns table information 
By Crosbie Christopher 2008/10/23 | Source: | Category: stored procedures
Rating: |  Discuss |   Briefcase | 1,333 reads

Finding all data types in user tables

A quick way to get a snapshot of what data types are being used in all user tables.  Read more...
By Gaby Abed 2008/12/04 | Source: | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 1,057 reads

The Ultimate Column Searcher

Searches for columns with names containing @Colname that belong to tables with names containing @TableName or schemas with names containing @SchemaName. Gives size and rowcount for tables.  Read more...
By Jesse Roberge 2009/10/16 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 1,371 reads

Column Level Permissions

GRANT Column Level Permissions 
By Mani Singh 2008/06/08 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,760 reads
   Items 1 to 14 of 14