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

Search the boards