架构与分区表

7.2：架构

例一：为用户啊zhang创建一个名为S_C的架构

create schema S_C authorization zhang

例二：定义一个用隐含名字的架构

create schema authorization zhang…%隐含名字就叫zhang%

例三

create schema TEXT authorization zhang.........................................%为用户zhang定义名为TEXT的架构，表T1在架构内%
   creat table T1(
                            c1 int,
                            c2 char(10),
                            c3 smalldatetime,
                            c4 numeric(4,1)
                         )

例四 删除架构

drop schema <架构名 >(只能删除空白的架构)

…
…
…

7.3：分区表

例1

create partition function myRangPF1(int)
as range left for values( 1,10,100);

例2

create partition function myDateRangPF1(datetime)
as range right for values (' ',' ',' ', ' ', ' ', ' ',......);

例3

create partition function myrangePF1(int)
   as range right for values(1,10,100)
go
create partition function myrangePS1
    as partition myrangePF1
    to (test1fg,test2fg,test3fg,test4fg);
go
create table partitiontable(   col1 int,
                                                     col2 char(10), 
                                                   )
                         on myrangePS1(col1)

…
…
…