for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?php
namespace Spatie\MigrateFresh\TableDroppers;
use Illuminate\Support\Facades\DB;
class Sqlsrv implements TableDropper
{
private $dropScript = '
while(exists(select 1 from INFORMATION_SCHEMA.TABLE_CONSTRAINTS where CONSTRAINT_TYPE=\'FOREIGN KEY\'))
begin
declare @sql nvarchar(2000)
SELECT TOP 1 @sql=(\'ALTER TABLE \' + TABLE_SCHEMA + \'.[\' + TABLE_NAME + \'] DROP CONSTRAINT [\' + CONSTRAINT_NAME + \']\')
FROM information_schema.table_constraints
WHERE CONSTRAINT_TYPE = \'FOREIGN KEY\'
exec (@sql)
end
while(exists(select 1 from INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA != \'sys\'))
declare @sql1 nvarchar(2000)
SELECT TOP 1 @sql1=(\'DROP TABLE \' + TABLE_SCHEMA + \'.[\' + TABLE_NAME + \']\')
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA != \'sys\'
exec (@sql1)
end';
public function dropAllTables()
DB::unprepared($this->dropScript);
}
spatie /
laravel-migrate-fresh
