SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, columns Rss

   Items 1 to 4 of 4   
 

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 | 771 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

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,362 reads

Column Level Permissions

GRANT Column Level Permissions  Read more...
By Mani Singh 2008/06/08 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,793 reads
   Items 1 to 4 of 4   
 
Tags
administration (2)    
::fn_listextendedproperty (1)    
find foreign key using sql (1)    
maintenance and management (1)    
permissions (1)    
search (1)    
single (1)    
sql server 2005 (1)    
stored procedures (1)    
system tables (1)    
table field information (1)    
table metadata (1)    
tables (1)    
unused (1)    
utility (1)    
value (1)