Suggest an editImprove this articleRefine the answer for “How do you select all columns of a table?”. Your changes go to moderation before they’re published.Approval requiredContentWhat you’re changing🇺🇸EN🇺🇦UAPreviewTitle (EN)Short answer (EN)To select every column of a table, use the `*` symbol in a `SELECT` command, e.g. `SELECT * FROM Employees;` - this pulls every column and every record, unless a `WHERE` is specified. **Key point:** it's convenient for quickly browsing the whole table, but on large tables with many columns, using `*` can be inefficient - it's better to select only the fields you actually need.Shown above the full answer for quick recall.Answer (EN)ImageTo select **every column of a table**, use the `*` symbol in a `SELECT` command. **Syntax:** ```sql SELECT * FROM Table_Name; ``` **Example:** ```sql SELECT * FROM Employees; ``` ### What this query does - Pulls **every column** (`ID`, `Name`, `Age`, `DepartmentID`, etc.) from the `Employees` table. - Shows **every record**, unless a `WHERE` is specified. **Notes:** - Convenient for quickly browsing an entire table. - On large tables with many columns, using `*` can be inefficient, it's better to select only the fields you need. > Put simply, `SELECT *` is a way to **pull all of a table's data at once**.For the reviewerNote to the moderator (optional)Visible only to the moderator. Helps review go faster.