MAXNOP8

SQL Server, SSIS, powershell

Tuesday, October 16, 2012

How to select column names of a table

select COLUMN_NAME  from INFORMATION_SCHEMA.COLUMNS where  TABLE_NAME ='my_table'
Posted by Christophe at 12:04 AM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Tsql

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2016 (1)
    • ►  January (1)
  • ►  2015 (4)
    • ►  December (2)
    • ►  November (1)
    • ►  October (1)
  • ►  2014 (8)
    • ►  August (3)
    • ►  July (1)
    • ►  May (1)
    • ►  March (1)
    • ►  February (1)
    • ►  January (1)
  • ►  2013 (14)
    • ►  September (3)
    • ►  August (3)
    • ►  July (1)
    • ►  April (2)
    • ►  March (5)
  • ▼  2012 (16)
    • ►  November (2)
    • ▼  October (5)
      • SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED
      • SQL Template to delete SQL job, maintenance plan a...
      • Free sql online formatter tool
      • sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029)
      • How to select column names of a table
    • ►  September (1)
    • ►  August (2)
    • ►  July (6)

About Me

Christophe
View my complete profile
Awesome Inc. theme. Powered by Blogger.