背景:故意修改Kubernetes叢集所在伺服器節點上的時間使Kubernetes憑證過期,重新頒發憑證後,使用kubeadm alpha certs check-expiration命令檢視憑證有效時間,相關憑證都已重新核發。
12/29/2023使用以下Select,組出修改Table定序的Script語法 --需要先選擇DB,在使用這段Script --如果Column有綁Index、FK、PK ,無法直接跑Script,要從Table>設計>Column屬性去修改 SELECT * from ( SELECT ('ALTER TABLE ' + quotename(TABLE_NAME) + ' ALTER COLUMN ' + quotename(COLUMN_NAME) + ' ' + quotename(DATA_TYPE) + CASE WHEN CHARACTER_MAXIMUM_LENGTH = -1 then '(max)' WHEN DATA_TYPE in ('text','ntext') then ''
1/3/2023※危險,慎用!! DECLARE @Sql NVARCHAR(500) DECLARE @Cursor CURSOR SET @Cursor = CURSOR FAST_FORWARD FOR SELECT DISTINCT sql = 'ALTER TABLE [' + tc2.TABLE_SCHEMA + '].[' + tc2.TABLE_NAME + '] DROP [' + rc1.CONSTRAINT_NAME + '];' FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS rc1 LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc2 ON tc2.CONSTRAINT_NAME =rc1.CONSTRAINT_NAME OPEN @Cursor FETCH NEXT FROM @Cursor INTO @Sql
1/3/2023極度危險, 慎用! EXEC sp_MSForEachTable 'TRUNCATE TABLE ?'
5/12/2022or
By clicking below, you agree to our terms of service.
New to HackMD? Sign up