sqlserver 删除数据,并且序号恢复从1开始
delete from article_author;dbcc checkident('article_author',reseed,0)delete from article_author;dbcc checkident('article_author',reseed,0)TRUNCATE TABLE tpl_template_class RESTART IDENTITY; ALTER SEQUENCE ...
delete from article_author;dbcc checkident('article_author',reseed,0)...
https://blog.csdn.net/h1773655323/article/details/142454517...
DROP TABLE IF EXISTS "public"."zj_gg"; CREATE SEQUENCE...
EXEC sys.sp_addextendedproperty @name=N'MS_Description',@level1type=N'TABLE...
lower(hex(randomblob(16)))...