# Migrations & Schema Builder (Laravel)

> Migrations creation, schema builder, column types, indexes, foreign keys, rollbacks, seeders, factories

- 20 interview questions
- Mid-Level
- [Interview Questions: Laravel](https://sharpskill.dev/en/technologies/laravel/interview-questions.md)

## 1. Which artisan command allows creating a new migration?

**Answer**

The make:migration command generates a new migration file in the database/migrations folder with an automatic timestamp. This command accepts a descriptive migration name and can use --create or --table options to automatically generate base code. Using this command ensures standardized structure and consistent naming of migrations.

## 2. Which Schema Builder method allows creating a new table?

**Answer**

The Schema::create() method allows creating a new table in the database. It takes two parameters: the table name and a closure that receives a Blueprint object to define columns. This method is used in the up() method of migrations to create new data structures.

## 3. Which column type should be used to store an auto-incrementing UNSIGNED BIGINT identifier?

**Answer**

The id() method creates an auto-incrementing UNSIGNED BIGINT column that serves as primary key. This is the recommended type for identifiers since Laravel 6, replacing increments(). This method automatically configures auto-increment and primary key constraint, simplifying table definition.

## 17 more questions available

- Which method allows adding created_at and updated_at columns to a table?
- Which artisan command executes all pending migrations?

Sign up for free: https://sharpskill.dev/en/login

## Other Laravel interview topics

- [PHP Basics](https://sharpskill.dev/en/technologies/laravel/interview-questions/php-basics.md): 25 questions, Junior
- [PHP OOP Essentials](https://sharpskill.dev/en/technologies/laravel/interview-questions/php-oop-essentials.md): 20 questions, Junior
- [Composer & Autoloading](https://sharpskill.dev/en/technologies/laravel/interview-questions/composer-autoloading.md): 18 questions, Junior
- [Laravel Fundamentals](https://sharpskill.dev/en/technologies/laravel/interview-questions/laravel-fundamentals.md): 20 questions, Junior
- [Laravel Routing](https://sharpskill.dev/en/technologies/laravel/interview-questions/laravel-routing.md): 20 questions, Junior
- [Blade Templates](https://sharpskill.dev/en/technologies/laravel/interview-questions/blade-templates.md): 18 questions, Junior
- [Request & Response](https://sharpskill.dev/en/technologies/laravel/interview-questions/request-response.md): 20 questions, Junior
- [Eloquent ORM Basics](https://sharpskill.dev/en/technologies/laravel/interview-questions/eloquent-orm-basics.md): 22 questions, Junior
- [Eloquent Relationships](https://sharpskill.dev/en/technologies/laravel/interview-questions/eloquent-relationships.md): 25 questions, Mid-Level
- [Validation & Forms](https://sharpskill.dev/en/technologies/laravel/interview-questions/validation-forms.md): 22 questions, Mid-Level
- [Authentication](https://sharpskill.dev/en/technologies/laravel/interview-questions/authentication.md): 20 questions, Mid-Level
- [Authorization & Policies](https://sharpskill.dev/en/technologies/laravel/interview-questions/authorization-policies.md): 18 questions, Mid-Level
- [API Resources & Authentication](https://sharpskill.dev/en/technologies/laravel/interview-questions/api-resources-authentication.md): 26 questions, Mid-Level
- [Middleware](https://sharpskill.dev/en/technologies/laravel/interview-questions/middleware.md): 18 questions, Mid-Level
- [Service Container & DI](https://sharpskill.dev/en/technologies/laravel/interview-questions/service-container-di.md): 20 questions, Mid-Level
- [Queues & Jobs](https://sharpskill.dev/en/technologies/laravel/interview-questions/queues-jobs.md): 22 questions, Mid-Level
- [Events & Listeners](https://sharpskill.dev/en/technologies/laravel/interview-questions/events-listeners.md): 18 questions, Mid-Level
- [Notifications & Mail](https://sharpskill.dev/en/technologies/laravel/interview-questions/notifications-mail.md): 20 questions, Mid-Level
- [File Storage](https://sharpskill.dev/en/technologies/laravel/interview-questions/file-storage.md): 18 questions, Mid-Level
- [Testing & PHPUnit](https://sharpskill.dev/en/technologies/laravel/interview-questions/testing-phpunit.md): 24 questions, Mid-Level
- [Caching](https://sharpskill.dev/en/technologies/laravel/interview-questions/caching.md): 18 questions, Mid-Level
- [Livewire & Inertia](https://sharpskill.dev/en/technologies/laravel/interview-questions/livewire-inertia.md): 20 questions, Mid-Level
- [Eloquent Advanced](https://sharpskill.dev/en/technologies/laravel/interview-questions/eloquent-advanced.md): 24 questions, Senior
- [Repository Pattern](https://sharpskill.dev/en/technologies/laravel/interview-questions/repository-pattern.md): 20 questions, Senior
- [Laravel Packages](https://sharpskill.dev/en/technologies/laravel/interview-questions/laravel-packages.md): 20 questions, Senior
- [Performance Optimization](https://sharpskill.dev/en/technologies/laravel/interview-questions/performance-optimization.md): 22 questions, Senior
- [Security Best Practices](https://sharpskill.dev/en/technologies/laravel/interview-questions/security-best-practices.md): 22 questions, Senior
- [Laravel Octane](https://sharpskill.dev/en/technologies/laravel/interview-questions/laravel-octane.md): 18 questions, Senior
- [Laravel Distributed Systems](https://sharpskill.dev/en/technologies/laravel/interview-questions/laravel-distributed-systems.md): 22 questions, Senior
- [Observability & Monitoring](https://sharpskill.dev/en/technologies/laravel/interview-questions/observability-monitoring.md): 20 questions, Senior
- [Deployment & DevOps](https://sharpskill.dev/en/technologies/laravel/interview-questions/deployment-devops.md): 20 questions, Senior

---

Source: SharpSkill (https://sharpskill.dev), tech interview preparation for your real stack.
HTML version of this page: https://sharpskill.dev/en/technologies/laravel/interview-questions/database-migrations