数据库简单语法

Sql数据库

delete from 表名;
truncate table 表名;

drop table tablename

select datename(HH,getdate())

drop table WareHouseingInfo

CREATE TABLE [dbo].[WareHouseingInfo] (
[ID ]int PRIMARY KEY IDENTITY(1,1),–主键自增
[Type] nvarchar(255) COLLATE Chinese_PRC_CI_AS NOT NULL,
[OrderNumber] nvarchar(255) COLLATE Chinese_PRC_CI_AS NOT NULL,
[Material_Number] nvarchar(200) COLLATE Chinese_PRC_CI_AS NULL,
[Material_Info] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
[WareHouseing] int NULL,
[Material_certificate] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
[TONumber] nvarchar(200) COLLATE Chinese_PRC_CI_AS NULL
)
GO
查询某表的所有列名
select count(*) from syscolumns s where s.id = object_id(‘M_BE_Config’);–表名大小写均可

///查询有多少列
select count(*) from user_tab_cols where table_name=‘表名’