Flashcards
MS SQL
Cards in this deck (9)
- 1Get a list of all databasesSELECT *
FROM master.dbo.sysdatabases - 2Get a list of all tablesSELECT
*
FROM
SYSOBJECTS
WHERE
xtype = 'U' - 3Get a list of all tables (alternative way)SELECT
*
FROM
INFORMATION_SCHEMA.TABLES - 4Get a list a description of a particular table all columnsEXEC sp_columns [table name]
- 5Show the current used database nameSELECT db_name()
- 6Access databaseUSE [database name]
- 7Get the top 100 rows of a particular tableSELECT TOP (100) [columns names list]
FROM [table name] - 8Enforce case sensitive selectSELECT [first_name]
FROM [table name]
WHERE BINARY [first_name] = 'First Person' - 9Assign ALIAS to a column original nameSELECT [first_name] AS 'Name'
FROM [table name]
Information
- Description
- Programming Flashcards on MS SQL, created by Magdoulin Shams El-Din on 21/09/2022.
- Created by
- Magdoulin Shams El-Din
- Views
- 0
- Rating