제가 sybase는 초보라 잘 않되는 군요.. 테이블 구조는
이러한데..
Name Owner
Object_type
------------------------------
------------------------------
--------------------------------
TCDSMS dbo
user table
(1 row affected)
Data_located_on_segment When_created
------------------------------ --------------------------
default Aug 24 2003 2:27AM
Column_name Type
Length Prec
Scale Nulls Default_name
Rule_name Access_Rule_name
Identity
------------------------------ ------------------------------
----------- ----
----- ----- ------------------------------
------------------------------
------------------------------ --------
USERID varchar
20 NULL
NULL 0 NULL
NULL NULL
0
HP1 varchar
4 NULL
NULL 0 NULL
NULL NULL
0
HP2 varchar
4 NULL
NULL 0 NULL
NULL NULL
0
HP3 varchar
4 NULL
NULL 0 NULL
NULL NULL
0
REGDATE varchar
8 NULL
NULL 0 TCDSMS_REGDAT_731146619
NULL NULL
0
index_name index_description
index_keys
index_max_rows_per_page index_fillfactor
index_reservepagegap
index_created
--------------------
--------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------- ----------------
--------------------
-------------------
PK_TCDGUEST nonclustered, unique located on default
USERID
0 0
0
Aug 24 2003 2:32AM
(1 row affected)
No defined keys for this object.
Object is not partitioned.
Lock scheme Datarows
exp_row_size reservepagegap fillfactor max_rows_per_page
identity_gap
------------ -------------- ---------- -----------------
------------
0 0 0 0
0
(1 row affected)
concurrency_opt_threshold optimistic_index_lock
dealloc_first_txtpg
------------------------- ---------------------
-------------------
15 0
0
(return status = 0)
sp_dropkey primary,TCDSMS 이걸로도 않없어지고
alter table TCDSMS drop constraint USERID 이걸로도 않없어
지는군요..
제가 명령어를 잘못쓴건지.. 아님 다른 명령어를 써야 하는지 ..
아시는분은 그냥 지나치지말고 답변좀 해주십시요.. ^^
|