Hocu da sa nedokumentiranom procedurom sp_MSForEachTable drop-am sve tabele u testnoj bazi. Napisao sam tsql kod
ali mi se javlja greska
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)
PS. baza je na sql server 2008
Code:
EXEC sp_MSForEachTable 'DROP TABLE ? NOCHECK CONSTRAINT ALL'
EXEC sp_MSForEachTable 'DROP TABLE ? NOCHECK CONSTRAINT ALL'
ali mi se javlja greska
Citat:
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'NOCHECK'.
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)
Citat:
CREATE PROCEDURE sp_EmplyAllTable
AS
EXEC sp_MSForEachTable ‘ALTER TABLE ? NOCHECK CONSTRAINT ALL’
EXEC sp_MSForEachTable ‘DELETE FROM ?’
EXEC sp_MSForEachTable ‘ALTER TABLE ? CHECK CONSTRAINT ALL’
GO
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
Potpis
...
