SQLServerCentral.com Scripts tagged columns

Tables and rows listing

Mon, 11 Feb 2013 07:00:00 UT

Simple script which create a list of all the tables and rows of the selected DB.

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

Search for String in all columns

Wed, 07 Nov 2012 07:00:00 UT

Find all columns containing a string value across all tables and schemas.

Table Search Based on the Column

Tue, 06 Nov 2012 07:00:00 UT

To Find all the tables based on a particular column

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.

Generate alter datatype script for entire database

Mon, 28 Nov 2011 07:00:00 UT

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.

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.

Display rows vertically

Mon, 05 Oct 2009 06:00:00 UT

A script to view selects of fat rows vertically with columns in alpha order

Search for a Column in all databases

Wed, 05 Aug 2009 06:00:00 UT

This Script can be used for searching a column in SQL server 2005

Object Search

Wed, 19 Oct 2011 06:00:00 UT

Search any database (or a combination databases, including all) for a specific string found in column names, object names, and /or object definitions.

Find Text in all columns of all tables in a Database

Thu, 31 Mar 2011 06:00:00 UT

Will find the Table Name, Column Name and the number of occurances some text appears in a database.

New! Safeguard your SQL backups
Protect your backups from onsite disaster with SQL Backup Pro and a Hosted Storage account from Red Gate. Learn more

Find a Table's Metadata

Thu, 23 Oct 2008 22:38:15 UT

Stored Procedure that returns table information

Finding all data types in user tables

Thu, 04 Dec 2008 07:00:00 UT

A quick way to get a snapshot of what data types are being used in all user tables.

The Ultimate Column Searcher

Fri, 16 Oct 2009 06:00:00 UT

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.

New! Safeguard your SQL backups
Protect your backups from onsite disaster with SQL Backup Pro and a Hosted Storage account from Red Gate. Learn more

Column Level Permissions

Sun, 08 Jun 2008 17:47:27 UT

GRANT Column Level Permissions

Make working with SQL a breeze
SQL Prompt 5 is the effortless way to write, edit, and explore SQL. It's packed with features such as code completion, script summaries, and SQL reformatting, that make working with SQL a breeze. Try it now.