Posted By: ceny (C~eny) on 'CZdatabases' Title: Re: Drop table statement Date: Fri Jun 25 10:30:29 2004 > Zdravim, > nevite nekdo jak se pise v sql skriptu pro oracle podmineny drop statement > > (drop pouze pokud tabulka existuje), pripadne da se v sql skriptu obalit > drop > statement odchycenim vyjimky? > To co zkousim nedela to co ma, pokousi se to dropovat tabulku i kdyz > neexistuje a tudiz to vyhodi vyjiku : > if exists(select 1 from sys.user_tables where table_name = 'T_USER') then > drop table t_user cascade constraints; > end if; vim to akorat pro MSSQL, treba to pomuze. if exists (select * from sysobjects where id = object_id(N'[T_USER]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [T_USER] GO v Ceny