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

Content with tag columns Rss

   Items 1 to 20 of 21    Older >>
 

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,489 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,308 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 2013/10/09 | Source: SQLServerCentral.com | Category: object
Rating: |  Discuss |   Briefcase | 3,226 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 | 968 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,575 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,175 reads

Understanding Column Properties for a SQL Server Table

Designing a table can be a little complicated if you don’t have the correct knowledge of data types, relationships, and even column properties. In this tip, Brady Upton goes over the column properties and provides examples.   Read more...
By Additional Articles 2012/10/26 | Source: MSSQLTips.com | Category: columns
Rating: (not yet rated)  Rate this |   Briefcase | 4,012 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 | 810 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 2013/10/09 | Source: SQLServerCentral.com | Category: object
Rating: |  Discuss |   Briefcase | 3,226 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,308 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,022 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 2013/10/09 | Source: SQLServerCentral.com | Category: object
Rating: |  Discuss |   Briefcase | 3,226 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,331 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,808 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 | 949 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 2013/10/09 | Source: SQLServerCentral.com | Category: object
Rating: |  Discuss |   Briefcase | 3,226 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 2013/10/09 | Source: SQLServerCentral.com | Category: object
Rating: |  Discuss |   Briefcase | 3,226 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,308 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,038 reads

Find a Table's Metadata

Stored Procedure that returns table information  Read more...
By Crosbie Christopher 2008/10/23 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 1,310 reads
   Items 1 to 20 of 21    Older >>
 
Tags
search (3)    
tables (3)    
t-sql (3)    
administration (2)    
data types (2)    
find (2)    
sql server 2005 (2)    
text (2)    
::fn_listextendedproperty (1)    
alter (1)    
change column (1)    
data (1)    
data exploration (1)    
dba (1)    
defaults (1)    
definition (1)    
find foreign key using sql (1)    
image (1)    
information_schema (1)    
kurtosis (1)    
list (1)    
locate (1)    
maintenance and management (1)    
metadata (1)    
metrics (1)    
miscellaneous (1)    
ntext (1)    
object (1)    
object name (1)    
object search (1)    
permissions (1)    
quartiles (1)    
queries (1)    
range (1)    
select (1)    
single column in whole database tables (1)    
skew (1)    
standard deviation (1)    
statistics (1)    
stored procedures (1)    
string (1)    
sys.columns (1)    
sys.systypes (1)    
sys.tables (1)    
system tables (1)    
table field information (1)    
table metadata (1)    
table search (1)    
triggers (1)    
unpivot (1)    
utility (1)