Posted by John Bell on 12/11/05 22:43

Hi

I assume you have found books online that will give you a great deal of
information regarding language/tools etc... the latest version can be
downloaded from
http://www.microsoft.com/downloads/details.aspx?FamilyID=a6f79cb1-a420-445f-8a4b-bd77a7da194b&DisplayLang=en

This will give you information on sp_help (and similar procedures) which
will give information regarding an object.

Scripting can be done from Enterprise Manager, the General SQL option will
create a script to create the object which can be written to a file or
pasted into another window. This can usually be found by right clicking the
item in the tree view.

There are also scripting options in Query Analyser if you display the object
browser. This gives you multiple options regarding how you want to script it
and where output should go. This is also usually a right click option.

John


You can look at sp_help
"stig" <_nospam_stigerikson@yahoo.se> wrote in message
news:dnhumd$ioi$1@oden.abc.se...
> hi.
> coming from postgresql, i am used to textual references to most of the
> things i do with the database. i feel a little lost with all the
> graphical.
>
> i have few questions regarding MS SQL 2000
> 1. what is the best (or easiest) way of getting a table definition in
> text?
> it could be either a CREATE TABLE sql-query or a just a definition,
> something like:
> TABLE thisTable
> id integer
> value varchar(10)
> etc. etc.
>
>
> 2a. how do i get a query plan and how do i get it in text.
> 2b. are there planner modes that show more or less of what actually
> happened, verbose mode perhaps?
> 2c. if i ask for a query plan, will SQL server actually run the query or
> will it only produce a plan. if the query is run, does it commit or
> rollback by default?
>
>
> stig

[Back to original message]