h1

Cap19. Lucru cu information schema view

March 25, 2010

Totul despre tabele sistem:

Creare mdf si ldf fisiere:

Adaugare fisiere si grupuri fisiere la bd existente:

Arhitectura single respectiv multi pt.bd

In a single-database architecture (such as that used by a DB2 or ORACLE SQL Server), the DBMS supports (and manages) a single database. (The database may consist of multiple physical files, but all database objects exist in a single logical database file.)

Multi-server:

A multi-database architecture, as shown in Figure 498.2, lets you group tables (by owner) within multiple database files. Instead of keeping tables for multiple applications in the same database file (as is the case in a single-database architecture), each database will normally support a single (or set of related) applications. When you add a new, different application, you will typically create a new database to hold that tables used to support it.

Raport vanzari mssql:

1) Schema check constraints view

2) Folosire COLUMN_DOMAIN

3) Schema COLUMN_PRIVILEGES

4) Schema column views

5) Schema CONSTRAINT_COLUMN_USAGE

6) Schema CONSTRAINT_TABLE_USAGE

7) Schema DOMAIN_CONSTRAINTS

8) Schema DOMAIN

9) Schema KEY_COLUMN_USAGE

10) Schema PARAMETERS

11) Schema REFERENTIAL_CONSTRAINTS

12) Schema ROUTINES

13) Schema SCHEMATA

14) Schema Table_Constraints

15) Schema Table_Privileges

16) Schema tables

17) Schema VIEW_COLUMN_USAGE

18) Schema VIEW_TABLE_USAGE

19) Schema ROUTINE_COLUMNS

20) Schema VIEWS View

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: