why cant i create this table ????
USE amit

IF OBJECT_ID('dbo.member_details') IS NOT NULL
DROP TABLE dbo.member_details

GO

CREATE TABLE member_details
(
member_id int NOT NULL constraint member_id_no primary key
, member_name name NOT NULL
, member_rigion char(2) NOT NULL constraint member_rigion check (member_rigion like '(ta) , (ha) , (aa) , (by)')
)

GO


SELECT table_name
FROM information_schema.tables
WHERE table_name = 'member_details'



Server: Msg 2715, Level 16, State 7, Line 2
Column or parameter #2: Cannot find data type name.
table_name
--------------------------------------------------------------------------------------------------------------------------------

(0 row(s) affected)