exist Archives - anydragon

table 존재 안할때 table 생성

drop 
  table tempdb;
if exists (
  select 
    * 
  from 
    sysobjects 
  where 
    name = 'tempdb' 
    and xtype = 'U'
) create table cars111 (
  Name0 varchar(64) not null, 
  Name1 varchar(64) not null, 
  Name2 varchar(64) not null
);
select 
  * 
from 
  INFORMATION_SCHEMA.COLUMNS 
where 
  table_name = 'cars111' 
  and column_name = 'Name0';

drop

table tempdb;

if exists (

select

from

sysobjects

where

name = 'tempdb'

and xtype = 'U'

) create table cars111 (

Name0 varchar(64) not null,

Name1 varchar(64) not null,

Name2 varchar(64) not null

);

select

from

INFORMATION_SCHEMA.COLUMNS

where

table_name = 'cars111'

and column_name = 'Name0';

anydragon

참고자료

최신 글

보관함

table 존재 안할때 table 생성

태그

링크

메타