Skip to content

Instantly share code, notes, and snippets.

@Shuaib-8

Shuaib-8/SQL_data_types_check.sql

Created March 2, 2020 13:13
Show Gist options
  • Save Shuaib-8/4ca46b134805a78bb019a74fcc34d02f to your computer and use it in GitHub Desktop.
Save Shuaib-8/4ca46b134805a78bb019a74fcc34d02f to your computer and use it in GitHub Desktop.
Download ZIP
SQL determining data types sanity check
Raw
SQL_data_types_check.sql
-- Get the column name and data type
SELECT column_name, data_type
-- From the system database information schema
FROM INFORMATION_SCHEMA.COLUMNS
-- For the customer table
WHERE table_name = <'table_name'>;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment