view column data type sql
Solutions on MaxInterview for view column data type sql by the best coders in the world
{{#items}}
{{text}}
{{/items}} {{ctaText}}
{{#items}} {{/items}}
showing results for - "view column data type sql"
Alma
02 Nov 2017
1SELECT COLUMN_NAME, DATA_TYPE
2FROM INFORMATION_SCHEMA.COLUMNS
3WHERE TABLE_NAME = 'yourTableName'
4similar questions
write a query to display the column name and data type of the table employee oracle see column typeget column name sql serverget table column names sql ssmsget columns number sqlsql query to get column names and data types in sql serversql typeswhat are the data types in sqlshow the colums of table sqlview column type sql serverhow to check data type in sql serverhow to view column names of a table in sqlchange column data type sqlsearch for column name in sql db when i don 27t know which table it is insql data typessql show columns in tableview in sql serverchecking data type in sql serverdata types in sqlsql show table name in result your answer for
you will get a confirmation link on this - you will have to click that for successful submission of your answer. we require this to keep the website free of spam, bots and unhelpful content
please ensure to add code which is syntactically corrent and executes properly
ask question on maxinterview
you will get a confirmation link on this - you will have to click that for successful submission of your question. we require this to keep the website free of spam, bots and unhelpful content
please be clear, to the point and respectful