Errors and Solutions

Tuesday, February 5, 2019

[SQL] Get column name from Table




select * from [DBName].Information_schema.columns
where table_name = 'final_outgoing_323'


Posted by Hoon at 7:46 AM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

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

About Me

Hoon
View my complete profile

Blog Archive

  • ►  2021 (1)
    • ►  May (1)
  • ▼  2019 (26)
    • ►  May (1)
    • ►  April (1)
    • ►  March (9)
    • ▼  February (5)
      • [SQL] UPDATE TABLE
      • [SQL] ISNUMERIC CAST REPLACE
      • [SQL] SELECT ISNULL(NULL, 'TEST');
      • [SQL] Get column name from Table
      • [SQL] Having clause with Group By and Where
    • ►  January (10)
  • ►  2018 (7)
    • ►  October (2)
    • ►  September (3)
    • ►  July (2)
  • ►  2017 (2)
    • ►  October (1)
    • ►  September (1)
  • ►  2015 (2)
    • ►  September (2)
Simple theme. Powered by Blogger.