SQL

Start Here Glossary WHERE INSERT (Create) SELECT (Read) UPDATE DELETE Join Tables Sub Query Limit Records SQL Injection SSMS Meta Data Sum TABLE Apostrophe Date Identity
O O

Weather Controls

Time Of Day
Rain
Wind Speed
Wind Direction
Clouds

SQL : Meta Data

2018-03-08

Get List of column Names in Table.

SELECT Column_name FROM Information_schema.columns WHERE Table_name LIKE 'robsAwesomeTable'

Get Name of Table

Can be used to check if table exists dynamically.

SELECT * FROM Information_schema.tables WHERE Table_name LIKE 'robsAwesomeTable'

Get length of varchar Fields

SELECT column_name, data_type, character_maximum_length FROM information_schema.columns WHERE table_name like 'robsAwesomeTable'