Sql

SELECT COLUMN_NAME, DATA_TYPE 
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE TABLE_NAME = 'yourTableName'

sp_help TableName

PREVIOUS	NEXT

Code Example
Sql :: set max_allowed_packet mysql
Sql :: could not find driver (SQL: PRAGMA foreign_keys = ON;)
Sql :: return names of columns in table sql
Sql :: finding duplicate column values in table with sql
Sql :: create database if not exists
Sql :: oracle enable job
Sql :: Add 2 hours to current time in MySQL
Sql :: string to int mysql
Sql :: sql add year to date
Sql :: how to increase size of column in sql
Sql :: mysql date minus 1 day
Sql :: install mysql on mac
Sql :: find mysql version linux
Sql :: sql dateadd hours
Sql :: python sqlite3 create table if not exists
Sql :: Find all tables containing column with specified name - MS SQL Server
Sql :: get the list of all tables in sql server
Sql :: tsql get beginning of year
Sql :: sql between date range
Sql :: mysql remove unique constraint
Sql :: postgresql datetrunc too slow
Sql :: tsql create unique index composite
Sql :: command line mysql import
Sql :: create table if not exists sql
Sql :: oracle list next running jobs
Sql :: Erreur SQL sur la requête Index column size too large. The maximum column size is 767 bytes.
Sql :: restart identity cascade
Sql :: zerar auto increment mysql
Sql :: sql remove first character from string
Sql :: insert postgres