All pastes #839338 Raw Edit

Mine

public sql v1 · immutable
#839338 ·published 2007-12-30 23:49 UTC
rendered paste body
DECLARE Tables CURSOR FORSELECT DISTINCT  QUOTENAME(TABLE_CATALOG) + '.' +     QUOTENAME(TABLE_SCHEMA) + '.' +    QUOTENAME(TABLE_NAME)FROM INFORMATION_SCHEMA.TABLESWHERE TABLE_TYPE = 'BASE TABLE'OPEN TablesDECLARE @table varchar(128)FETCH NEXT FROM Tables INTO @tableWHILE @@FETCH_STATUS = 0BEGIN  PRINT 'Deleting table ' + ISNULL(@table, '<NULL>')  IF @table IS NOT NULL  BEGIN    DELETE FROM @table  END  FETCH NEXT FROM Tables INTO @tableENDCLOSE TablesDEALLOCATE Tables