Very Computer

1.  The tables for which the constraints (e.g. pk, fk) are
created.  
How can I check them in the enterprise manager?  I am able
to see the columns in the tables and their indexes, but
not the constraints. Would you know how I can check them?

2.  My customer's DBA purged their all tables from a db
instance into a txt file, such as the one that I attach
here.  Would you happen to know how to do this as well?

3.  For the constraint which looks like:
CONSTRAINT [pk_Ptnr_PtnrId] PRIMARY KEY  CLUSTERED
        ([PartnerID]
        ) WITH  FILLFACTOR = 90  ON [PRIMARY]

What implications do CLUSTERED and FILLFACTOR have on the
key itself, given that the db server is set in a clustered
db environment.

Quote:> 1.  The tables for which the constraints (e.g. pk, fk) are
> created.
> How can I check them in the enterprise manager?  I am able
> to see the columns in the tables and their indexes, but
> not the constraints. Would you know how I can check them?

> 2.  My customer's DBA purged their all tables from a db
> instance into a txt file, such as the one that I attach
> here.  Would you happen to know how to do this as well?

> 3.  For the constraint which looks like:
> CONSTRAINT [pk_Ptnr_PtnrId] PRIMARY KEY  CLUSTERED
>   ([PartnerID]
>   ) WITH  FILLFACTOR = 90  ON [PRIMARY]

> What implications do CLUSTERED and FILLFACTOR have on the
> key itself, given that the db server is set in a clustered
> db environment.

1. Rclick/rclick you meant Rgiht click, i guess?
2. What is "BOL"?
3. Again "BOL"?

BOL = Books Online

It's the Microsoft documentation that ships with SQL Server.

Start | Programs | Microsoft SQL Server | Books Online

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.