SQL Server/T-SQL Tutorial/Constraints/uniqueidentifier

Sample Table Using the uniqueidentifier and NEWID() Function

   <source lang="sql">

4> 5> CREATE TABLE MyTable( 6> PK_ID uniqueidentifier NOT NULL 7> PRIMARY KEY 8> DEFAULT (NEWID ()), 9> Name char (30) NOT NULL 10> ) 11> GO 1> INSERT MyTable (Name) VALUES ("F") 2> INSERT MyTable (Name) VALUES ("W") 3> 4> 5> select * from MyTable 6> GO (1 rows affected) (1 rows affected) PK_ID Name

---

------------------------------

FABC1C4A-C8F9-4E2B-B648-0550D95A0EC6 F 6B9035E9-9A27-4D0A-820C-F19589CD1965 W (2 rows affected) 1> 2> drop table MyTable 3> GO 1></source>