SQL Clone
SQLServerCentral is supported by Redgate
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 20 of 20   

Find unused columns

Script finds all columns in a table that have a single value.  Read more...
By Clay Punnett 2016/11/28 | Source: SQLServerCentral.com | Category: columns
Rating: |  Discuss |   Briefcase | 917 reads

Index and Column Configuration

Returns the indexes in a database along with all of the columns in the index in a consolidated format  Read more...
By Tennery Press 2016/06/29 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 661 reads

Identify Column Data Types

Use the following queries to list a result set of all column data types to any specified database. In the 2nd query, you will see a result set based on all text based data type columns in your database (XML data type not included). Modify accordingly.  Read more...
By Rich Yarger 2014/04/07 | Source: SQLServerCentral.com | Category: datatypes
Rating: |  Discuss |   Briefcase | 1,209 reads

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: SQLServerCentral.com | Category: columns
Rating: |  Discuss |   Briefcase | 1,678 reads

Convert int to Excel column name

This script converts a numeric column index to an Excel column name (ex: AC)  Read more...
By Peter Diplaros 2013/11/07 | Source: SQLServerCentral.com | Category: excel
Rating: (not yet rated) |  Discuss |   Briefcase | 1,348 reads

Get all fields names for all tables in SQL

Script to generate all column names and table names  Read more...
By Raymond Xie 2013/07/10 | Source: SQLServerCentral.com | Category: notes
Rating: |  Discuss |   Briefcase | 1,567 reads

Locate a column across databases

This utility will locate a column across a subset or all databases across a server. Can be configured to run across versions, and can search tables, views or both.  Read more...
Rating: |  Discuss |   Briefcase | 1,203 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: SQLServerCentral.com | Category: tables
Rating: |  Discuss |   Briefcase | 1,045 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: SQLServerCentral.com | Category: search
Rating: |  Discuss |   Briefcase | 1,742 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: SQLServerCentral.com | Category: table search
Rating: |  Discuss |   Briefcase | 1,235 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: SQLServerCentral.com | Category: ntext
Rating: |  Discuss |   Briefcase | 845 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,041 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: SQLServerCentral.com | Category: select
Rating: |  Discuss |   Briefcase | 1,861 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: SQLServerCentral.com | Category: columns
Rating: |  Discuss |   Briefcase | 972 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 2015/12/23 | Source: SQLServerCentral.com | Category: object
Rating: |  Discuss |   Briefcase | 4,860 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: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 8,554 reads

Find a Table's Metadata

Stored Procedure that returns table information 
By Crosbie Christopher 2008/10/23 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 1,372 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: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 1,074 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: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,383 reads

Column Level Permissions

GRANT Column Level Permissions 
By Mani Singh 2008/06/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,807 reads
   Items 1 to 20 of 20