SELECT COLUMN_NAME, DATA_TYPE, IS_NULLABLE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME='your_table_name';
How to find records based on CAPITAL and small letters in SQL Query?
Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql st...
How to concatenate text from multiple rows into a single text string in SQL server?
Rename column SQL Server
How to solve "TableAdapter can't see stored procedure returned fields when using temp table" problem