Tablespaces and storages are generic objects used to represent physical locations (in named partitions) of tables and indexes in a database or storage device.
For some DBMSs, a tablespace can use a specified storage in its definition.
The following table lists the DBMSs that use concepts that are represented by tablespaces and storages in PowerDesigner:
| 
                             DBMS  | 
                             Tablespace represents...  | 
                             Storage represents...  | 
|---|---|---|
| 
                             ADABAS  | 
                             NA  | 
                             NA  | 
| 
                             IBM DB2 UDB Common Server  | 
                             tablespace create tablespace  | 
                             buffer pool create bufferpool  | 
| 
                             IBM DB2 UDB for OS/390  | 
                             table space create tablespace  | 
                             storage group create stogroup  | 
| 
                             Informix  | 
                             NA  | 
                             NA  | 
| 
                             Ingres  | 
                             NA  | 
                             NA  | 
| 
                             InterBase  | 
                             NA  | 
                             NA  | 
| 
                             Microsoft Access  | 
                             NA  | 
                             NA  | 
| 
                             Microsoft SQL Server  | 
                             NA  | 
                             filegroup alter database add filegroup...  | 
| 
                             MySQL  | 
                             NA  | 
                             NA  | 
| 
                             Oracle  | 
                             tablespace create tablespace  | 
                             storage structure (not physical storage)  | 
| 
                             PostgreSQL  | 
                             NA  | 
                             NA  | 
| 
                             Sybase ASA  | 
                             database space create dbspace  | 
                             NA  | 
| 
                             Sybase ASE  | 
                             NA  | 
                             segment sp-addsegment  | 
| 
                             Sybase AS IQ  | 
                             database space create dbspace  | 
                             NA  | 
| 
                             Teradata  | 
                             NA  | 
                             NA  |