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.
TN46_DB_DEFS.txt 34K Download |