Mega Code Archive

 

Categories / MSSQL Tutorial / Sequence Indentity

 

Identity column

3>  CREATE TABLE customer 4> ( 5> cust_id      int          IDENTITY  NOT NULL, 6> cust_name    varchar(30)  NOT NULL, 7> CONSTRAINT customer_PK PRIMARY KEY (cust_id) 8> ) 9> GO 1> 2> EXEC sp_helpconstraint customer 3> GO Object Name -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- customer constraint_type                                                                                                                                    constraint_name                                                                             delete_action update_action status_enabled status_for_replication constraint_keys -------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------- --------------------------------------------------------------------------- ------------- ------------- -------------- ---------------------- ---------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------- PRIMARY KEY (clustered)                                                                                                                            customer_PK                                                                             (n/a)         (n/a)         (n/a)          (n/a)                  cust_id No foreign keys reference table 'customer', or you do not have permissions on referencing tables. 1> drop table customer; 2> GO