| title | description | ms.reviewer | ms.date | ms.topic | ms.search.form |
|---|---|---|---|---|---|
Create a SQL database in the Fabric portal |
Learn how to create a SQL database in Microsoft Fabric in the Fabric portal. |
antho, sukkaur, dlevy |
09/05/2025 |
how-to |
product-databases, Get Started, Databases Get Started for SQL |
Applies to: [!INCLUDE fabric-sqldb]
In this tutorial, create a new SQL database in Fabric.
- SQL database in Microsoft Fabric is enabled by default.
- You need an existing Fabric capacity. If you don't, start a Fabric trial.
- You can use an existing workspace or create a new Fabric workspace.
- You must be a member of the Admin or Member roles for the workspace to create a SQL database.
- In the Fabric portal, select Databases.
- Under New, select the tile for SQL database.
- Provide a name for the New Database. Select Create.
- When the new database is provisioned, on the Home page for the database, notice the Explorer pane showing database objects.
- Under Build your database, three useful tiles can help you get your newly created database up and running.
- Sample data option lets you import a sample data into your Empty database.
- T-SQL option gives you a web-editor that can be used to write T-SQL to create database object like schema, tables, views, and more. For users who are looking for code snippets to create objects, they can look for available samples in Templates drop down list at the top of the menu.
- Connection strings option shows the SQL database connection string that is required when you want to connect using SQL Server Management Studio, the MSSQL extension for Visual Studio Code, or other external tools.
- Consider adding your new database to source control. For more information, see SQL database source control integration in Microsoft Fabric.
[!div class="nextstepaction"] Load AdventureWorks sample data in your SQL database