Find all tables containing column with specified name Many developers asking is it possible to find a column name in all tables which has columns specified name. So here is query to search a column in a SQL Server database. Search in all tables SELECT c.name AS 'Column', t.name AS 'TableName' FROM sys.columns c JOIN sys.tables t ON c.object_id = t.object_id WHERE c.name = 'MycolumnName' --specify search column name ORDER BY TableName,Column Search in all tables and views SELECT COLUMN_NAME AS 'Column', TABLE_NAME AS 'TableName' FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME = 'MyColumnName' --specify search column name ORDER BY TableName,Column;

Detect screen break point inside the component jsx itself

Rathnakar

I have the following component:

    <Stack direction="row" spacing={2}>
      <Skeleton variant="rounded" animation="wave" sx={{ width: 1 }} />
      <Loading
        text="Loading..."
        sx={{ position: 'relative', background: 'none', color: 'grey' }}
        recommendedSolutions={
          <LoadingBtn
            onClick={refetch}
            variant="outlined"
            loadingIndicator="Refetching data..."
            loading={loading}
          >
            Try again
          </LoadingBtn>
        }
      />
    </Stack>

I want to be able to change the direction prop of the Stack component based on the screen breakpoint. The question is:

I can use the grid component to solve this problem as follows:

    <Grid container>
      <Grid item sx={{ display: { xs: 'none', md: 'block' } }}>
        <Stack direction="row" spacing={2}>
          <Skeleton variant="rounded" animation="wave" sx={{ width: 1 }} />
          <Loading
            text="Loading..."
            sx={{ position: 'relative', background: 'none', color: 'grey' }}
            recommendedSolutions={
              <LoadingBtn
                onClick={refetch}
                variant="outlined"
                loadingIndicator="Refetching data..."
                loading={loading}
              >
                Try again
              </LoadingBtn>
            }
          />
        </Stack>
      </Grid>
      <Grid item sx={{ display: { xs: 'block', md: 'none' } }}>
        <Stack direction="vertical" spacing={2}>
          <Skeleton variant="rounded" animation="wave" sx={{ width: 1 }} />
          <Loading
            text="Loading..."
            sx={{ position: 'relative', background: 'none', color: 'grey' }}
            recommendedSolutions={
              <LoadingBtn
                onClick={refetch}
                variant="outlined"
                loadingIndicator="Refetching data..."
                loading={loading}
              >
                Try again
              </LoadingBtn>
            }
          />
        </Stack>
      </Grid>
    </Grid>

but this makes me repeat similar code, is there a way I can do it within the direction prop of the Stack component itself? it's a tough task to write that much code