1vLZm8ae

1if  exists
2            (
3                select  *
4                    from    sysobjects
5                    where   id  =   object_id   (   N'dbo.DSTRNP'   )
6                        and OBJECTPROPERTY  (   id, N'IsUserTable'  )   =   1
7            )
8    drop    table   dbo.DSTRNP
9go
10
11create  table   dbo.DSTRNP
12    (
13        TEST    char(12)    not null
14            ,   constraint  pk_c_DSTRNP primary key clustered
15            (
16                TEST
17            )
18    )
19go