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 14 of 14   
 

Find database where table is located

Return a list of databases which contain a table from wildcard table name.  Read more...
By Trevor Makoni 2014/05/05 | Source: SQLServerCentral.com | Category: find
Rating: |  Discuss |   Briefcase | 1,027 reads

SQL Server Tables

By Snigdha Vartak 2013/08/27 | Category: table
Rating: (not yet rated) |  Discuss |   Briefcase | 2,513 reads

Enable/Disable a table to be read only on the fly

Wouldn't be nice if we can set the "read only" property of any table to be on or off easily with one simple stored procedure call?  Read more...
By Steven Rao 2013/07/30 | Source: SQLServerCentral.com | Category: read only
Rating: |  Discuss |   Briefcase | 6,908 reads

Find Primary Column of all tables in database

This code helps in finding Primary Keys for all tables in a database.  Read more...
By Nitesh Dedhia 2012/10/02 | Source: SQLServerCentral.com | Category: primary key (pk)
Rating: |  Discuss |   Briefcase | 1,339 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 2012/08/30 | Source: SQLServerCentral.com | Category: table
Rating: |  Discuss |   Briefcase | 2,284 reads

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,425 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 | 2,241 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 2010/08/04 | Source: SQLServerCentral.com | Category: table
Rating: |  Discuss |   Briefcase | 1,414 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 2010/08/04 | Source: SQLServerCentral.com | Category: table
Rating: |  Discuss |   Briefcase | 1,414 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,610 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 | 2,009 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 2008/08/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 878 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 2008/08/05 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 456 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 2012/08/30 | Source: SQLServerCentral.com | Category: table
Rating: |  Discuss |   Briefcase | 2,284 reads
   Items 1 to 14 of 14   
 
Tags
t-sql (5)    
advanced querying (2)    
check constraint (2)    
counter (2)    
development (2)    
foreign keys (fk) (2)    
indexing (2)    
miscellaneous (2)    
nums (2)    
primary key (pk) (2)    
sqlinsider scripts (2)    
table of numbers (2)    
tally (2)    
administration (1)    
automation (1)    
calculate (1)    
clustering (1)    
constraints (1)    
create (1)    
database (1)    
dynamic sql (1)    
estimate (1)    
execute (1)    
find (1)    
heap (1)    
loop (1)    
metadata (1)    
non-clustered (1)    
read only (1)    
size (1)    
space (1)    
sql server 2005 (1)    
sql server 7 (1)    
tables (1)    
trigger (1)    
unique (1)    
used (1)    
xml (1)