Re: describe table

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Steve Z (SteveZ_at_discussions.microsoft.com)
Date: 07/02/04 

Date: Fri, 2 Jul 2004 07:21:01 -0700

One of the ten commandments at our shop is to SCRIPT EVERYTHING.

That means we make a TEXT file with an extension of .SQL and put our TABLE create right in there. We building indexes and constraints right in that script. We have control over naming our indexes.

We script STORED PROCEDURE creation. We script the GRANTing of rights to SPROCS in the same script.

Changes made in the GUI can get lost and never make it to production servers.

Having EM or QA create a script from the database is flawed - it doesn't have everything associated with that table or sproc...

At least that's the way we do it - and it's been very successful in a rapid development/get the software to the customer scenario over the past 3 years.

"David Portas" wrote:

> Query Analyzer will script any table individually. Just right-click on the
> table in the Object Browser and select Script to New Window As > Create.
> Enterprise Manager will allow you to script multiple objects to a single
> file or script an entire database if you wish.
>
> --
> David Portas
> SQL Server MVP
> --
>
>
>

Quantcast