清空表内容
delete from article_author;dbcc checkident('article_author',reseed,0)ALTER TABLE public.qx SET SCHEMA qy;...
TRUNCATE TABLE tpl_template_class RESTART IDENTITY; ALTER SEQUENCE ...
SELECT A.attnum AS "序号",C.relname AS "表名",CAST (ob...
CREATE SEQUENCE rw_fl_id_seq START 1;重新生成序列:如果是自动递增字段,可能需要重置序列,特别是在删除记录之后。例如,执行以...
select zph_chrq.qyid,zph_chrq.lxdh as phone,qy.qymc from zph_chrq INNER join qy on zph_chrq.qy...
SELECT datname AS database_name, oid ...