SQL Server/T-SQL Tutorial/Constraints/uniqueidentifier

Sample Table Using the uniqueidentifier and NEWID() Function

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>