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]')
)

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...