use db;
set nocount on;
if exists( select 'x' from information_schema.tables
where
lower( table_name ) = 'sql_detail_methods'
)
begin
drop table [sql_detail_methods];
end;
Microsoft AX 2012, X++, C#, SQL server, SSRS, Java, JavaFX, Oracle, PL/SQL, Delphi - codes examples, step-by-step tutorials, experiences.
Wednesday, December 6, 2017
SQL SERVER - How drop table (with table exists check)
This example shows script for drop table with check if this table exists in DB.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment