create database T_mydb2

create database T_mydb2
on primary --配置主数据文件
(
    name = ‘T_mydb‘, --逻辑名称，数据库内部用的名字
    filename=‘D:\Data\T_mydb2.mdf‘,--保存路径
    size=5MB,--设置初始化后大小
    filegrowth=10MB,--设置增长速度
    maxsize=100MB--设置最大大小
)
log on --配置主日志文件
(
    name=‘T_mydb_log‘,
    filename=‘D:\Data\T_mydb_log2.ldf‘,
    size=3MB,
    filegrowth=3%,
    maxsize=20MB
)

drop database T_mydb2

use T_mydb2

create table T_Dict
(
    Id int primary key,
    Name nvarchar(10)
)
create table T_Product
(
    Id int primary key identity(1,1),
    Name nvarchar(10) not null,
    UnitPrice decimal(14,2),
    TypeId int,
    foreign key(Id) references T_Dict(Id)
)

select * into t_dict_new from T_Dict

drop table T_Product

alter table T_Dict add  Note nvarchar(255)

alter table T_Dict alter column Note nvarchar(100)

alter table T_dict_new add primary key(id)

create view view_getAllDict
as
select * from T_Dict

exec sp_helptext view_getAllDict

select * from view_getAllDict

drop view view_getAllDict

create index index_id
on T_dict(id)