给表加备注
EXEC sys.sp_addextendedproperty @name=N'MS_Description',@level1type=N'TABLE',@level0type=N'SCHEMA',@level0name=N'dbo', @value=N'操作日志' , @level1name=N'pub_member_opear_log'
EXEC sys.sp_addextendedproperty @name=N'MS_Description',@level1type=N'TABLE',@level0type=N'SCHEMA',@level0name=N'dbo', @value=N'操作日志' , @level1name=N'pub_member_opear_log'
https://blog.csdn.net/h1773655323/article/details/142454517...
SELECT datname AS database_name, oid ...
EXEC sys.sp_addextendedproperty @name=N'MS_Description',@level1type=N'TABLE...
CREATE SEQUENCE stu_id_seq SELECT setval( 'stu_id_seq', &nbs...
ALTER TABLE qy_gw ALTER COLUMN id SET DEFAULT nextval('q...
SELECT format( 'SELECT setval(%L, COALESCE((SELE...