Need Assistance: Constraints in a table specific

Need Assistance: Constraints in a table specific

Post by irfa » Sun, 08 Sep 2002 06:51:07



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
 
 
 

1. Need Assistance: Constraints in a table

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

2. Visual basic and Foxpro

3. Need Assistance: Clustering and constraints in a table

4. Uninstall 6.5 from production server

5. Need Assistance: Clustering and Constraints in a table

6. Queries and triggers across multiple databases.

7. How to detect error in SQLAnywhere + PowerBuilder?

8. Changing a table-level constraint to a column-specific constraint

9. send specific oracle 8i table data to specific sql server 2000 table at specific times

10. Urgently need assistance, Corrupt table!

11. REPOST - Assistance needed with clearing out Child tables

12. Assistance needed with creating tables in oracle.