Collections:
"DROP LOGIN" - Deleting a Login Name in SQL Server
How To Delete a Login Name in SQL Server?
✍: FYIcenter.com
If you don't want to keep a login name any more, you should delete it by using the "DROP LOGIN" statement as shown in this tutorial example:
-- Login with "sa" DROP LOGIN Dba_Login; GO Command(s) completed successfully. -- View login names SELECT name, sid, type, type_desc FROM sys.server_principals WHERE type = 'S'; GO name sid type type_desc -------- ----------------------------------- ---- --------- sa 0x01 S SQL_LOGIN FYI_DBA 0x348AF32B3B58CB40B67A5F5B7086B96E S SQL_LOGIN
⇒ "CREATE USER" - Creating a User Name in a Database in SQL Server
⇐ "ALTER LOGIN" - Disabling a Login Name in SQL Server
2016-10-19, 1546🔥, 0💬
Popular Posts:
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...