|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
-- drop table cars111; -- 다시 만들 때만 if not exists ( select * from sysobjects where name = 'cars111' 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'; |