xxxxxxxxxx
SELECT name, crdate FROM SYSOBJECTS WHERE xtype = 'U';
-- or
SELECT * FROM INFORMATION_SCHEMA.TABLES
-- or
SELECT * FROM databaseName.INFORMATION_SCHEMA.TABLES;
xxxxxxxxxx
SELECT c.name AS 'ColumnName'
,t.name AS 'TableName'
FROM sys.columns c
JOIN sys.tables t ON c.object_id = t.object_id
WHERE c.name LIKE '%MyName%'
ORDER BY TableName
,ColumnName;
xxxxxxxxxx
BY LOVE SINGH
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG='YOUR_Database_name'
xxxxxxxxxx
SELECT
TABLE_SCHEMA AS TABLE_SCHEMA
,TABLE_NAME AS TABLE_NAME
,COLUMN_NAME AS COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
--Where COLUMN_NAME Like '%Put_Your_Comumn_Name_HERE%'
ORDER BY
TABLE_SCHEMA
,TABLE_NAME
,COLUMN_NAME;
xxxxxxxxxx
SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'your_table_name';
xxxxxxxxxx
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
AND TABLE_SCHEMA = 'your_database_name';
xxxxxxxxxx
SELECT COLUMN_NAME AS 'ColumnName'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_NAME LIKE '%assembly_armatureassy_tbl%'
and COLUMN_NAME LIKE '%supplied%'
xxxxxxxxxx
import sqlite3
# Connect to the database
connection = sqlite3.connect('your_database.db')
cursor = connection.cursor()
# Replace 'your_table' with the actual table name
table_name = 'your_table'
# Execute a query to retrieve the column names
cursor.execute(f"PRAGMA table_info({table_name})")
# Fetch all rows containing column information
columns = cursor.fetchall()
# Extract the column names (2nd item in each row)
column_names = [column[1] for column in columns]
# Print the column names
for column_name in column_names:
print(column_name)
# Close the database connection
connection.close()