SQL

phone no data type in sql server

create table MyTable
(
    PhoneNumber char(10)
        constraint CK_MyTable_PhoneNumber check (PhoneNumber like '[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]')
)

what data type to use for phone number in sql

phone varchar(10) NOT NULL UNIQUE

phone number data type in sql

Phone number can be INT and also you type as varchar

datatype for phone number in sql

You can use char(15) i would use 15 instead of 10 as some international numbers can be up to 15 digits
Or you could use Varchar(19) to cater for other characters and country codes e.g. +123 etc...