테이블 생성은 간단히 됬는데 key를 하나도 잡지 못했습니다.
간단한 예문 부탁드립니다.
alter table 사용하여 잡는 예문도 좋고
table create 하면서 같이 잡아주는 방법이 있으면 그것도 알려 주시면 감사하겠습니다.
매뉴얼을 보세요
1. alter table_name add constraint constrain_name primary key (컬럼명)
2. create table - Creates new tables and optional integrity constraints. create table [database.[owner].]table_name (column_name datatype [default {constant_expression | user | null}] {[{identity | null | not null}] [off row | in row] [[constraint constraint_name] {{unique | primary key} [clustered | nonclustered] [asc | desc] [with { fillfactor = pct, max_rows_per_page = num_rows, } reservepagegap = num_pages }] [on segment_name] | references [[database.]owner.]ref_table [(ref_column)] | check (search_condition)}]}... | [constraint constraint_name] {{unique | primary key} [clustered | nonclustered] (column_name [asc | desc] [{, column_name [asc | desc]}...]) [with { fillfactor = pct max_rows_per_page = num_rows , reservepagegap = num_pages } ] [on segment_name] |foreign key (column_name [{, column_name}...]) references [[database.]owner.]ref_table [(ref_column [{, ref_column}...])] | check (search_condition) ... } [{, {next_column | next_constraint}}...]) [lock {datarows | datapages | allpages }] [with { max_rows_per_page = num_rows, exp_row_size = num_bytes, reservepagegap = num_pages, identity_gap = num_values } ] [on segment_name] [ [ external table ] at pathname ]