EXEC sp_MSForEachTable 'DROP TABLE ? NOCHECK CONSTRAINT ALL'
ali mi se javlja greska
Incorrect syntax near the keyword 'NOCHECK'.
Gdje grijesim? Druge komande poput print (exec sp_MSforeachtable 'print ''?''' ) rade. Inace ovu komandu sam prepravio od originalne koja glasi ovako (ona samo brise podatke iz tabela)
AS
EXEC sp_MSForEachTable ‘ALTER TABLE ? NOCHECK CONSTRAINT ALL’
EXEC sp_MSForEachTable ‘DELETE FROM ?’
EXEC sp_MSForEachTable ‘ALTER TABLE ? CHECK CONSTRAINT ALL’
GO
PS. baza je na sql server 2008