SQL to show all column or field names of the specified table

Home >

8. March 2011

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '<TableNameGoesHere>'

Tags: SQL

430e2d39-7762-4733-b31b-f65a008a1c66|0|.0

MySQL Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't existThis means that mysql cannot find the table it uses to store usernames. It may be corrupt or deleted...Delete duplicate rows from table in SQLSuppose there is a table called "EmployeeTable" which have some duplicate records. Ther...Installing SQL Server 2005 Reporting Services on a Windows Vista-based computerNote SQL Server 2005 Enterprise Edition is not supported on Windows Vista. you need to install any ...

Beyond web logs