postgresql 删除数据，并且序号恢复从1开始

浪淘沙7个月前 (08-07)数据库129

TRUNCATE TABLE tpl_template_class RESTART IDENTITY;
ALTER SEQUENCE tpl_template_class_id_seq RESTART WITH 1;

返回列表

https://blog.csdn.net/h1773655323/article/details/142454517...

EXEC sys.sp_addextendedproperty @name=N'MS_Description',@level1type=N'TABLE...

SELECT format( 'SELECT setval(%L, COALESCE((SELE...

select zph_chrq.qyid,zph_chrq.lxdh as phone,qy.qymc from zph_chrq INNER join qy on zph_chrq.qy...

ALTER TABLE public.qx SET SCHEMA qy;...

SELECT A.attnum AS "序号",C.relname AS "表名",CAST (ob...

xxt.red 校校通