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

Content with tag INFORMATION_SCHEMA Rss

   Items 1 to 7 of 7   
 

Generate Column Metadata

This utility will generate column and parameter metadata in various useful formats for tables, views, and procedures.  Read more...
By Steven Willis 2013/02/12 | Source: SQLServerCentral.com | Category: utility
Rating: |  Discuss |   Briefcase | 558 reads

Using TOP To Rank Columns In a Table

This article covers the use of the TOP clause to select data from a table based on the TOP n columns in a table.  Read more...
By Tim Parker 2011/10/25 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 6,326 reads

INFORMATION_SCHEMA.101

Get information about the objects in your database using these ANSI standard, multi-platform views.  Read more...
By Tom Powell 2011/10/04 | Source: SQLServerCentral.com | Category: information_schema
Rating: |  Discuss |   Briefcase | 5,721 reads

Query-generated Column Expressions

A technique from Bill Nicolich that allows you to target columns by data type for the same custom expression and easily build complex queries.  Read more...
By Bill Nicolich 2010/05/25 | Source: SQLServerCentral.com | Category: information_schema
Rating: |  Discuss |   Briefcase | 8,552 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,805 reads

View - Table Usage (Recursive)

Written to explore the table dependencies of a view, especially when the view queries other views.  Read more...
By Rhett Clement 2009/01/22 | Source: SQLServerCentral.com | Category: schema
Rating: |  Discuss |   Briefcase | 984 reads

Querying the INFORMATION_SCHEMA

Using a macro to query the INFORMATION_SCHEMA  Read more...
By Mike DiRenzo 2008/03/03 | Source: SQLServerCentral.com | Category: information_schema
Rating: |  Discuss |   Briefcase | 12,005 reads
   Items 1 to 7 of 7   
 
Tags
t-sql (2)    
administration (1)    
columns (1)    
dependencies (1)    
format (1)    
metadata (1)    
recursive function (1)    
schema (1)    
select (1)    
sql server 2005 (1)    
sql server 2008 (1)    
top (1)    
unpivot (1)    
utility (1)