SQLServerCentral: Content tagged Table

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,252 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,264 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,371 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,169 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,381 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,381 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,518 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,963 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 2013/06/19 | Source: SQLServerCentral.com | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 864 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 2013/06/19 | Source: SQLServerCentral.com | Category: t-sql

Rating: (not yet rated) |

Discuss |

Briefcase | 442 reads