Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQL Create User FOR vs. FROM

Tags:

sql

sql-server

Is there any substantive difference between these two SQL statements, as I see them used for the same end goal of creating a database user based off a SQL Login

CRETE USER myusername FOR LOGIN myusername

CREATE USER myusername FROM LOGIN myusername
like image 583
Kode Avatar asked Sep 19 '25 13:09

Kode


1 Answers

Same thing; just different syntax.

like image 88
vvvv4d Avatar answered Sep 21 '25 06:09

vvvv4d