return columns from table sql
SELECT *
FROM INFORMATION_SCHEMA.COLUMNS -- INFORMATION_SCHEMA is an ANSI-standard (American National Standard Institute) set of read-only views which provide information about all of the tables, views, columns, and procedures in a database
WHERE TABLE_NAME = N'Customers' -- "N" defines the subsequent string (the string after the N) as being in unicodeSQL SELECT
Mit SELECT können Daten aus der Datenbank abgefragt werden. Es ist die am
meissten verbreitete Art.
SELECT name
FROM country
WHERE region = (
SELECT region
FROM country
WHERE name = 'Brasilien'
)Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
