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


 

Content with tag Table Rss

   Items 1 to 9 of 9   
 

Get information from tables

Give information in tables such as type size and description of each of the columns  Read more...
By kenneth9 2011/07/08 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |  Briefcase | 1,113 reads

Stored procedure to script tables, has many options

I needed a fast way of creating identical copies of multiple tables. The criteria was to make identical copies of tables for a specific schema. Well there it started.  Read more...
By Gokhan Varol 2011/02/01 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |  Briefcase | 1,972 reads

Find botched constraints, idxs, fks

Shows awesome view of columns with constraints and indexes and foreign keys to spot errors fast.  Read more...
By William Talada 0001/01/01 | Source: SQLServerCentral.com | Category: table
Rating: |  Discuss |  Briefcase | 1,340 reads

Find botched constraints, idxs, fks

Shows awesome view of columns with constraints and indexes and foreign keys to spot errors fast.  Read more...
By William Talada 0001/01/01 | Source: SQLServerCentral.com | Category: table
Rating: |  Discuss |  Briefcase | 1,340 reads

Estimating the table size...

This is an effort to program the "Estimating the Table size" section given in BOL.   Read more...
By sql frenzy 2009/07/02 | Source: SQLServerCentral.com | Category: table
Rating: |  Discuss |  Briefcase | 1,378 reads

Loop Through every table in a DB

This Script has been build to list all the tables in a database without using a cursor.   Read more...
By Chris Morton 2009/01/20 | Source: SQLServerCentral.com | Category: metadata
Rating: |  Discuss |  Briefcase | 1,884 reads

Counter Table (table of numbers) Setter-Upper for SQL Server 2005

Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 622, 386884, and 240641848 numbers.  Read more...
By Jesse Roberge | Source: SQLServerCentral.com | Category: t-sql aids
Rating: (not yet rated) |  Discuss |  Briefcase | 829 reads

Counter Table (table of numbers) Setter-Upper for SQL Server 2000

Sets up 3 'table of numbers' that completely fill a 1, 2, and 3-level clustered index respectivly with 620, 384400, and 238328000 numbers.  Read more...
By Jesse Roberge | Source: SQLServerCentral.com | Category: t-sql aids
Rating: (not yet rated) |  Discuss |  Briefcase | 435 reads

Insertion Query Creation of a Table in Milliseconds

This script helps you to constitute insertion procedures for tables in a millisecond.  Read more...
By emreguldogan 2008/01/03 | Source: SQLServerCentral.com | Category: table
Rating: |  Discuss |  Briefcase | 1,198 reads
   Items 1 to 9 of 9   
 
Tags
t-sql (4)    
advanced querying (2)    
counter (2)    
development (2)    
foreign keys (fk) (2)    
indexing (2)    
miscellaneous (2)    
nums (2)    
sqlinsider scripts (2)    
table of numbers (2)    
tally (2)    
t-sql aids (2)    
administration (1)    
automation (1)    
calculate (1)    
check constraint (1)    
clustering (1)    
constraint (1)    
create (1)    
dynamic sql (1)    
estimate (1)    
execute (1)    
heap (1)    
loop (1)    
metadata (1)    
non-clustered (1)    
primary key (pk) (1)    
size (1)    
space (1)    
sql server 2005 (1)    
sql server 7 (1)    
unique (1)    
used (1)    
xml (1)    
 
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.