|
|
Posted by stig on 12/11/05 21:31
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
Navigation:
[Reply to this message]
|