SQL Server/T-SQL/Sequence/IDENTITYCOL

Select IDENTITYCOL

   <source lang="sql">

13> 14> -- SELECT Statement and IDENTITY Property 15> 16> CREATE TABLE product 17> (product_no INTEGER IDENTITY(10000,1) NOT NULL, 18> product_name CHAR(30) NOT NULL, 19> price MONEY) 20> 21> insert into product (product_name) values ("Soap"); 22> GO (1 rows affected) 1> 2> SELECT IDENTITYCOL 3> FROM product 4> WHERE product_name = "Soap" 5> GO product_no

---

     10000

(1 rows affected) 1> 2> drop table product 3> GO 1>

      </source>