1.建表

drop table e_user;

create table e_user (
	id INT IDENTITY(1,1) PRIMARY KEY,
	username VARCHAR(50) NOT NULL,
	email VARCHAR(100) NOT NULL UNIQUE,
    dept_id     bigint  ,
    all_money     money  ,
	created_time DATETIME DEFAULT GETDATE()
) ;

2.插入建表，通过 select into 来建表

select * into e_regions
FROM [YYXCX].[dbo].[z_regions];

3.创建，修改视图，sql

create view v_aaa as select * from t_user;

alter view v_aaa as select * from t_user;