SQL statement to get column type

by

Using SQL Server:

SELECT DATA_TYPE 
FROM INFORMATION_SCHEMA.COLUMNS
WHERE 
     TABLE_SCHEMA = 'yourSchemaName' AND
     TABLE_NAME   = 'yourTableName' AND 
     COLUMN_NAME  = 'yourColumnName'

More Related Contents:

  1. How do you version your database schema? [closed]
  2. Designing a SQL schema for a combination of many-to-many relationship (variations of products)
  3. How do I change db schema to dbo
  4. How can I insert a new database record in the middle of an existing table?
  5. Convert text to system date format [duplicate]
  6. How to get a particular preceding value of a column in SQL [closed]
  7. Whats wrong in this sql query? It throws error [closed]
  8. How to select just the row in the second table?
  9. Update statement with inner join on Oracle
  10. SQL update from one Table to another based on a ID match
  11. What is the meaning of the prefix N in T-SQL statements and when should I use it?
  12. Is there any function in oracle similar to group_concat in mysql? [duplicate]
  13. SQL Joins Vs SQL Subqueries (Performance)?
  14. Check if a row exists, otherwise insert
  15. coalesce alternative in Access SQL
  16. Split column into multiple rows in Postgres
  17. Export SQL query data to Excel
  18. Spark sql queries vs dataframe functions
  19. Performance issue in using SELECT *? [duplicate]
  20. SQL SELECT to get the first N positive integers
  21. When to Denormalize a Database Design
  22. How to read the contents of an .sql file into an R script to run a query?
  23. SQL INNER JOIN syntax
  24. Select distinct from multiple fields using sql
  25. What is the most appropriate data type for storing an IP address in SQL server? [duplicate]
  26. How do MySQL views work?
  27. Using Raw SQL with Doctrine
  28. How to bulk insert only new rows in PostreSQL
  29. ORA-00933: SQL command not properly ended
  30. Update a table with data from another table

Leave a Comment