--使用数据库 [xhcum]
use [xhcum]
--创建项目表
create table projects
(
projectId int identity(1,1) primary key, --主键,自动标识
projectName varchar(200),
projectPlace varchar(200),
projectAmount decimal(16,2),
projectContent varchar(max)
)
----查询表结构
select a.COLUMN_NAME,a.DATA_TYPE,a.CHARACTER_MAXIMUM_LENGTH,b.value
from information_schema.COLUMNS as a left join sys.extended_properties as b
on a.TABLE_NAME=OBJECT_NAME(b.major_id) and a.ORDINAL_POSITION=b.minor_id where a.TABLE_NAME='p_requirement'
----修改列
alter table p_requirement alter column subordinateBranch varchar(200)
----添加列
ALTER TABLE projects ADD org_id int