When you create a database with SQL Server, using the most accurate data type of the table columns you create…